Results 1 to 3 of 3

Thread: Excel.

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Bannaned underweaver's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 8,116

    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.

  2. #2
    Registered User
    Join Date: May:2005
    Location:
    Posts: 933
    Repair- Add/Remove programs. , , , .

  3. #3
    The Black Beret  's Avatar
    Join Date: Oct:2006
    Location:
    Posts: 8,417
    :
    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.
    .
    Molṑn Labe

    , .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |