Hi there, I read the topics about the excel errors others have... I don't think, mine is the same. :-(
Export to Excel AND CSV is not working:
- Excel: it says, there is a problem reading the file and Excel repairs the File... but a lot of content is missing after that. There is no difference between open the file directly or save it first and then open (see "explanation of Error-Messages" and "ExcelFile" Picture)
- CSV: It exports all the content without error-messages, but not each entry is on one single row! there are entries that use 2 rows and rows without entrys...
Help! I could export the file directly from the database, but for the users is this not possible to handle... and all the special characters (as ä, ö, ü are replaced by fancy characters)
Thanks so much in advance in thinking about my problem!
Greatings from Switzerland (where it snows heavily at the moment😀 )
Charlotte
Export to Excel AND CSV is not working:
- Excel: it says, there is a problem reading the file and Excel repairs the File... but a lot of content is missing after that. There is no difference between open the file directly or save it first and then open (see "explanation of Error-Messages" and "ExcelFile" Picture)
- CSV: It exports all the content without error-messages, but not each entry is on one single row! there are entries that use 2 rows and rows without entrys...
Help! I could export the file directly from the database, but for the users is this not possible to handle... and all the special characters (as ä, ö, ü are replaced by fancy characters)
Thanks so much in advance in thinking about my problem!
Greatings from Switzerland (where it snows heavily at the moment😀 )
Charlotte
Hi Charlotte,
Your problems are most likely the same as other users have found. There are several possible causes: characters set issues and memory timeouts are the most common. There are some fixes for these suggested in the long thread on Excel export.
The CSV records are probably broken because the data contains commas, line feeds or carriage returns and the standard CSV export doesn't always recognise and quote these fields correctly.
There isn't enough information in the images you posted to give a clue about the cause of the failure in your case.
You may be better hand-coding the Excel export to meet your particular needs.
Bob
PS There is a document that you can buy here that pulls together most of the suggestions from the forum threads here and has an example of a hand-coded export frm a large database.
Your problems are most likely the same as other users have found. There are several possible causes: characters set issues and memory timeouts are the most common. There are some fixes for these suggested in the long thread on Excel export.
The CSV records are probably broken because the data contains commas, line feeds or carriage returns and the standard CSV export doesn't always recognise and quote these fields correctly.
There isn't enough information in the images you posted to give a clue about the cause of the failure in your case.
You may be better hand-coding the Excel export to meet your particular needs.
Bob
PS There is a document that you can buy here that pulls together most of the suggestions from the forum threads here and has an example of a hand-coded export frm a large database.
Hi Bob
Thanks for your answer (within 15min!!!, wow :-))
I bought your paper and hope I can find the solution...
Thanks! Charlotte
Thanks for your answer (within 15min!!!, wow :-))
I bought your paper and hope I can find the solution...
Thanks! Charlotte
Hi flikflauder,
I'm guessing that the cells has extended because of many characters. Try making all the cell not in 'Word Wrap' format.
Please tell me if it works.😉
__________
Having a bad hair problem? How about:Hair Extension Training Academy, Human Hair Extensions and Lace Front Wigs
I'm guessing that the cells has extended because of many characters. Try making all the cell not in 'Word Wrap' format.
Please tell me if it works.😉
__________
Having a bad hair problem? How about:Hair Extension Training Academy, Human Hair Extensions and Lace Front Wigs
This topic is locked and no more replies can be posted.
