C1 Community

Using C1.C1Excel.C1XLBook.Load (version 2.1.20082.87) to read an XLSX file with 200 columns and 4 rows, if I check the value of cell(0,0) it starts with the contents of the 27th column. To create the original file, I opened a new instance of Excel 2007, Typed A_1 in cell A1 and drug it accross to create data A_1 - A_200 in the first row. I then put data in the next 3 rows and drug them across to create data as well and saved the file.

Using the following code will result in my data now starting at A_27 with no sign of the original first 26 columns of data.  Any help would be greatly appreciated.

I'm using Visual Studio 2005 SP1 on Windows Vista SP1.

Dim XL As New C1.C1Excel.C1XLBook

Dim fileStr as string = "C:\myNewFile.XLSX"

 I do not experience these problems using an XLS (2003) file.

<PCI_Steve> wrote in message news:204586@10.0.1.98...

Using C1.C1Excel.C1XLBook.Load (version 2.1.20082.87) to read an XLSX file with 200 columns and 4 rows, if I check the value of cell(0,0) it starts with the contents of the 27th column. To create the original file, I opened a new instance of Excel 2007, Typed A_1 in cell A1 and drug it accross to create data A_1 - A_200 in the first row. I then put data in the next 3 rows and drug them across to create data as well and saved the file.

Using the following code will result in my data now starting at A_27 with no sign of the original first 26 columns of data.  Any help would be greatly appreciated.

I'm using Visual Studio 2005 SP1 on Windows Vista SP1.

Dim XL As New C1.C1Excel.C1XLBook

Dim fileStr as string = "C:\myNewFile.XLSX"

XL.Load(fileStr, True)

XL.Save(fileStr)

 I do not experience these problems using an XLS (2003) file.

---

http://helpcentral.componentone.com/cs/forums/p/75160/204586.aspx#204586