Exporting to excel GridLine,worksheet name,

I am Exporting my report to excel.

1, One thing i want's is to have gridlines available {not by borderstyle } when report is exported to excel.

2,I am inserting page break after a table to put different data on different sheet.How can i name the resultant work sheet {like table1 should be DATA,table2 should be MYSummary}

3,Can I insert page break after any control like simple textbox or it is necessary to put in a table ?

Hello Kamii,

1. I'm not sure if it is possible to turn on the gridlines only when exported since the export is supposed to match the formatting of the report, but someone else might have an idea. Would exporting to CSV work for you?

2. Changing the names of sheets isn't currently supported. Here's a post of the same, with a possible workaround. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=442744&SiteID=1

3. You can't add a page break after a textbox, but you can add one after a Rectangle. So, just create a rectangle, set the 'page break after', then add your textbox inside the rectangle.

Hope this helps.

Jarret

|||

I need these answers too. It would be nice if someone knowledgeable would respond.

Thanks!