This project has moved and is read-only. For the latest updates, please go here.

Sheet name without $

Apr 30, 2012 at 3:37 PM

Is there a way to create a new sheet with out the dollar sign being added to the sheet name. The dollar sign is seen when opening the file and looking at the sheets with  OLEDB and the  OLEDBSCHEMA Table but not with excel

Thanks

 

Apr 30, 2012 at 5:41 PM

Doesn't the dollar sign appear when you create the file in Excel and then open it via oledb?

May 2, 2012 at 1:52 PM

Yes , When I create a spreadsheet with excel the Dollar Sign is in the sheet name. Is there no way to supress this with Closed XML?

When I was using straight XML in 2003 I could name the sheet without the dollar sign.

Thanks

 

May 2, 2012 at 3:17 PM

I don't think so. Although you can make an XML file that can be opened by Excel, it's not *really* an Excel file.