Data not pulled from cell.

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Run the attached project
2. Notice in the xlsx file (in the bin\Debug directory) the value in D12 has 
the value "TextPickLetters, ImageV, AudioChooseA"
3. Notice the console output.  The value from D12 is not displayed.

What is the expected output? What do you see instead?
The expected output is for the 11th section object to have its media names 
populated.  Instead an empty string is passed into the method.  This is 
presumably because the column next to it or values above it are empty.

What version of the product are you using? On what operating system?
Latest version from NuGet.  Should be in the project.
OS = Win 7

Please provide any additional information below.
please let me know if there is anything else you need, or if you are unable to 
reproduce the problem. paqogomez at gmail dot com

Original issue reported on code.google.com by paqogo...@gmail.com on 2 Feb 2012 at 9:01

Attachments:

• linqtoexcel_bug_test.zip

[GoogleCodeExporter]

I downloaded the project, and I don't see the spreadsheet in the bin\Debug 
directory.

I opened the solution and it didn't compile either.

Can you try creating another zip package and attaching it.

Original comment by paulyo...@gmail.com on 14 Feb 2012 at 10:12

[GoogleCodeExporter]

Ok, fixed the project and made sure the spreadsheet is in the correct folder.  
Sorry for the mixup.

Original comment by crthomp...@gmail.com on 25 Feb 2012 at 4:35

Attachments:

• linqtoexcel_bug_test.zip

[GoogleCodeExporter]

This issue is caused by a limitation in Excel.

Excel determines the data type of a column by looking at the first 11 rows, and 
since the first 11 rows are blank in your spreadsheet, Excel thinks all the 
rows are blank.

I added some text in the first row, and it works fine. I attached the 
spreadsheet I used to show it as well.

Original comment by paulyo...@gmail.com on 15 Mar 2012 at 9:41

• Changed state: Fixed

Attachments:

• linqtoexcell_bug_test.xlsx