18
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
#1
André Arnaud de Cal...
294,145
Super User 2025 Season 1
#2
Martin Dráb
232,896
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
