Results 1 to 3 of 3
Thread: Excel.
Hybrid View
-
19th May 2010 14:22 #1
Excel.
,
Office 2003, - Excel. , , : Cell Data too large. Mo ? XP Pro 3, Office 2003.2nd Lt. George Rice: Looks like you guys are going to be surrounded.
Richard Winters: We're paratroopers, Lieutenant. We're supposed to be surrounded.
-
19th May 2010 14:38 #2Registered User
Join Date: May:2005
Location:
Posts: 933
Repair- Add/Remove programs. , , , .
-
19th May 2010 16:08 #3
:
.So, it happens that I was opening a simple Microsoft Excel xls spreadsheet containing some data feeds. Up came this uninvited error message box telling me that Cell Data Too Large. Very informative indeed.
Browsing thorugh the help file helped me get to this:
Length of cell contents (text) 32,767 characters.
Only 1,024 display in a cell; all 32,767 display in the formula bar
So its really the total number of characters in a cell thats causing the problem. But it seems to apply only on xls file.
The solution?
I dump the same data to a CSV file from the database. CSV is simply a comma seperated values (ex. i, am, david) text file, while XLS is a binary file (you will see strange text if you open it using notepad).
And after doing that, the CSV opens up fine with no complaints at all.




Reply With Quote
R9 280,
7th May 2023, 21:28 in