Issue Related With Export to Excel in Asp.net

Suite and Optimus Suite 5
#1

Hi,
I am able to export to DHTMLXGrid into Excel,but i have some problem and requirement related with this.

  1. When i export the data into excel it’s also showing footer row. so form where i can change this setting?

  2. How can i change this color of row format the rows?

3 . How can i change the excel file name and excel sheet. For example i have n pages where i am using export to excel so i want to use n different excel file name and the excel sheet name?

currently its fixed filename=grid.xlsx
Sheet name is : First Sheet

So please give me some sample code i am using asp.net .

Thanks,
Indramani

#2

  1. footer can be removed
    writer.PrintFooter = false;

  2. How can i change this color of row format the rows?
    there is a public properties for colors, check
    ExcelWriter.ScaleOneColor
    ExcelWriter.ScaleTwoColor
    ExcelWriter.BGColor

Row format isn’t configurable, you’ll have to modify the sources in order to change it

  1. How can i change the excel file name and excel sheet. For example i have n pages where i am using export to excel so i want to use n different excel file name and the excel sheet name?
    file name can be set explicitely, see the code from my other post(the code for ExcelWriter will be the same)
    viewtopic.php?f=23&t=25533#p81535

but for the sheet name you’ll have to modify the sources

#3

Hi,
To remove footer from exported Excel, you recommended to use
writer.PrintFooter = false;

Can you plz elaborate, where to add this code?. In generate.ashx page or in html code?

Thanks

#4

Also where can I set these properties (which page/what part of code)

ExcelWriter.ScaleOneColor
ExcelWriter.ScaleTwoColor
ExcelWriter.BGColor

Thanks

#5

Hi,
my mistake, current released version doesn’t contain these properties, sorry.
You may check the latest dev version of the export tool
s3.amazonaws.com/uploads.hipcha … el-net.zip

all code goes to generate.ashx

#6

Hi Aliaksandr,
That worked. Thanks