Hi karakoc49,
Could you please try with the current version? exportdata makes only ‘xls’ export, not ‘xlsx’ and is deprecated as a data export functionality.
Also we have a new data export using a method called “exportview”.
Best regards,
Peter Stoev
jQWidgets Team
https://www.jqwidgets.com/
Hello,
I’m currently using jQWidgets v16.0.0 (2023-Mar) and working with jqxGrid to display and export tabular data. However, I’ve noticed that when I export to Excel using jqxGrid(‘exportdata’, ‘xlsx’, …), the column headers appear with black background and black text, making them unreadable.
Is there a way to change the column headers’ background colors?
Hi Chris,
At present, we do not support export of grid aggregates. I added a work item about this missing functionality.
Best regards,
Peter Stoev
jQWidgets Team
https://www.jqwidgets.com/
Hi there,
when exporting
“$(“#jqxgrid”).jqxGrid(‘exportview’, ‘xlsx’, ‘umsatzreport’);”
and I have aggregates (e.g. sum cells below)
these sum cells will noch be exported.
What to do?
Regards
Chris
Hi I am using React js version 22.0.0 to use JQX forms , and whenever I try to use getComponentByName() function i am getting undefined as a output . This is my code:
import React, { useRef, useEffect } from “react”;
import { JQXForm } from “jqwidgets-react/react_jqxform”;
const MyForm = () => {
const myFormRef = useRef(null);
useEffect(() => {
// Call getComponentByName after the form has been rendered
if (myFormRef.current) {
const submitButton = myFormRef.current.getComponentByName(“submitButton”);
if (submitButton) {
console.log(“Submit Button Component:”, submitButton);
} else {
console.error(“Submit Button not found!”);
}
}
}, []);
const template = [
{
type: “text”,
name: “name”,
label: “Name:”,
labelPosition: “left”,
},
{
type: “button”,
name: “submitButton”,
text: “Submit”,
},
];
return <JQXForm ref={myFormRef} template={template} />;
};
export default MyForm;
Hi I am using React js version 22.0.0 to use JQX forms , and whenever I try to use getComponentByName() function i am getting undefined as a output . This is my code:
import React, { useRef, useEffect } from “react”;
import { JQXForm } from “jqwidgets-react/react_jqxform”;
const MyForm = () => {
const myFormRef = useRef(null);
useEffect(() => {
// Call getComponentByName after the form has been rendered
if (myFormRef.current) {
const submitButton = myFormRef.current.getComponentByName(“submitButton”);
if (submitButton) {
console.log(“Submit Button Component:”, submitButton);
} else {
console.error(“Submit Button not found!”);
}
}
}, []);
const template = [
{
type: “text”,
name: “name”,
label: “Name:”,
labelPosition: “left”,
},
{
type: “button”,
name: “submitButton”,
text: “Submit”,
},
];
return <JQXForm ref={myFormRef} template={template} />;
};
export default MyForm;
Hi Peter,
You are right $_SERVER[‘REMOTE_HOST’] Remote host is index that is not defined.
If I comment out part where you write export_log.txt file (in export.php script) all works, and I am able to open file.
a bit strange how this warning ends up in content.
Thanks.
Hi atomic,
Make sure the URL to your file is correct, because i opened this file with notepad and see “Notice: Undefined index: REMOTE_HOST in C:\wamp64\www\NEST\NEST\Api\PHPExport\export.php on line 6
” which basically means that the URL is incorrect.
Regards,
Peter Stoev
jQWidgets Team
https://www.jqwidgets.com/
Hi Peter,
Here is the file I get as exportPNG
ROI.png
When I try to open it it says File not supported.
Thanks
Hi atomic,
We use the same. I do not understand why you get this error. What is the type of the file after you export it?
Regards,
Peter Stoev
jQWidgets Team
https://www.jqwidgets.com/
I is quite simple.
I use export.php found in PHPExport folder in jqx source.
— REMOVE CODE —-
This is my button event handler.
$("#exportRoi").click(function() {
$("#ROIChart").jqxChart('saveAsPNG', 'ROI.png', 'Api/PHPExport/export.php');
});
This event click does export ROI.png, but when I try to open .png I get file not supported.
Thanks
-
This reply was modified 4 months, 3 weeks ago by admin.
-
This reply was modified 4 months, 3 weeks ago by admin. Reason: violation with copyright
Hi atomic,
Could you send us a jsfiddle example of this? Did you use the export.php file from the client portal which you can download from there because we use the same for export?
Regards,
Peter Stoev
jQWidgets Team
https://www.jqwidgets.com/
Hi,
I have developer license and have set up export.php server, I managed to get png or jpeg export but when I try to access these images I get error format not supported.
Any ideas would be appreciated.
Best
Hi Peter,
thanks. But I can’t find it?
I upgraded and use the “exportview” right now. But after the upgrade something happend I can’t explain
Another question is: Watch this:
https://gruppenhaus-manager.de/gm/test/cm_combo.php
There are three jqxDropDownLists. The first has a display error at the right.
The third one is missing the arrow down after setting the width to 22.
Any idea?
I only want a Dropdown list with a square and an arrow….
-
This reply was modified 4 months, 3 weeks ago by gruppenhaus.
Hi Chris,
dataexport.php is included in the source code download build which you can download from the client portal if you have a license. The login is your email and license key. As for the exportview, it takes the font of the grid and it depends on the theme applied.
Regards,
Peter Stoev
jQWidgets Team
https://www.jqwidgets.com/