Getting "Invalid bracketing of name" error when i try to run query on excel sheet

c# excel worksheet
Milosh N picture Milosh N · Jul 24, 2009 · Viewed 9k times · Source

In order to make some reports I need to parse some excel files. When I try to select records from sheet I get next error: Invalid bracketing of name '1. page$'.

Heres my code:

OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [1. page$]", connectionString);

I know it will work if I rename sheet to "page" for example, but as i'm not naming these sheets I need to know how to fix this query to work as it is. What should I do?

Answer

Greg picture Greg · Jan 31, 2014

I had this same problem, replaced the . with a # and it works. Thanks!

Related questions

C# - How to add an Excel Worksheet programmatically - Office XP / 2003

I am just starting to fiddle with Excel via C# to be able to automate the creation, and addition to an Excel file. I can open the file and update its data and move through the existing worksheets. My problem …

Read More
C#: Getting the number of rows/columns with ExcelPackage

I need to read and write data from an Excel spreadsheet. Is there a method to finding out how many rows/columns a certain worksheet has using ExcelPackage? I have the following code: FileInfo newFile = new FileInfo(@"C:\example.xlsx"); …

Read More
Change the background of Cells with C#

I'm developing an program using C# to manipulate an Excel document, and I'm using Microsoft.Office.Interop.Excel._Worksheet worksheet; When I insert something to a x,y cell I use : worksheet.Cells[x, y] = "something"; Now I want to …

Read More