5,901
hi all,
i have write code for excel export. it's working fine. i am using SysExcelApplication.
before printing the columns , i wants to display the report name same like in pic.
code example --
excelWorksheet.cells().item(m,1).value("@GDT458"); // 1st column of header
Kindly let me know how will acheive?
please give me more shed on this.
thanks!
Sure, but in line 5 in your code you have this mistake and you must fix it. Seems that you made a mistake when trying to apply the example code shared to you earlier. Please try to check the suggested code one more time.
The error message that you get is clear. Just pay attention to return value of the method that you use, and the type of the variable where you try to assign the return value.
It's line 5 in your code. I'm sure that the value() method is not returning such value (most likely it's not returning any value) that you could assign to your "com" variable. What are you trying to do with this line of code?
Share
Report
All responses (
Answers (
excelWorksheet.cells().item(m,1).value("@GDT523");
excelWorksheet.cells().item(m,1).font().bold(true);
m = 3;
com = excelWorksheet.cells().item(m,1).value("@GDT458");
com.backGroundcolor(WINapi::RGB2int(220, 220, 220));
i tried that, but it's throwing error
Operand types are not compatible with the operator.
please give me more shed on this.
hj
Its seems, changing background color of cells are not that easy, Not sure, its possible or not. I'm trying and let you know if succeed. FYI - The above code for background color will not work.
Uday
Hi,
Use this code to print the header,
excelWorksheet.cells().item(m, 1).value("Name you want");
excelWorksheet.cells().item(m, 1).font().bold(true);
M= 3;
Use this set the header background,
com = excelWorksheet.rows().item(3).comObject();
com.backGroundcolor(WINapi::RGB2int(220, 220, 220));
Then header prints as your code
Uday
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156