Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    Upgrade from what to what?

    What delimiter are you expecting?

    Thread Starter danof

    (@danof)

    I did the upgrade your plugin to the new version 2.10.21, sorry, but I do not know which version I was before the upgrade.

    What I would like when I open my .CSV file is to have my information stored in different columns that I do not have, even when I decide to define them with a tab. All my information is stored in a single column.

    Other problems I encounter this time with my .xlsx file is that I can not open Microsoft Office Excel 2007 and I get an error message.

    Can you tell me what configuration I need to do for my information are stored in different columns in my CSV file and to open the .xlsx file that I exported to Microsoft Office Excel 2007 without an error message?

    The error code on Microsoft Office Excel 2007 is 101590

    Plugin Author Michael Simpson

    (@msimpson)

    CSV: you may need to set the delimiter character when exporting. It is either comma or semicolon depending on your region. It is possible that WP thinks you are in on region, and Excel in another, so Excel does not read the delimiter right. Alternately, when opening a CSV file in Excel, open a blank document in Excel, then import the file. A dialog should appear that allows you to indicate the delimiter in the file.

    The error with .xlsx is news to me. What error are you getting? Do you mind sharing the spreadsheet? Email: info@cfdbplugin.com

    Thread Starter danof

    (@danof)

    I already tried this way and I still get the same result.

    Plugin Author Michael Simpson

    (@msimpson)

    A couple thoughts:

    Try renaming the file without the & and accent characters.

    If your WP install is in DEBUG mode, it may output unwanted debug text at the beginning of the file making it look corrupt. If you open the file in a text editor, you can see if there is any suspicious test at the top of the file.

    Thread Starter danof

    (@danof)

    my problem is that users use a new line when writing their information into text fields.
    And I do not know why when I export the file and I open it, microsoft excel considers the new line as the beginning in new column.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘problem when exporting xlsx and csv file’ is closed to new replies.