Sheet name without $

Apr 30, 2012 at 2: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



Apr 30, 2012 at 4: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 12: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.



May 2, 2012 at 2: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.