Import table via XLS, limit number of columns

  • Resolved lamberbee

    (@lamberbee)


    8 years, 6 months ago

    Hello,

    Thank you for this nice plugin. Playing with it right now.
    Doing an import via Excel files all the columns are shown, till the end of the Excel file.
    For Example: Only columns A-J are filled and need to be imported. But once imported, I see all columns, from A-IV … meaning I need to delete the columns K-IV.

    Is there some way to limit the number of columns during import?

    Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    I know what you mean, but unfortunately, I haven’t found a way around this yet ??
    Your best chance probably is to save the table to the CSV format and then import that.
    Otherwise, just delete the extra columns after the import.

    Regards,
    Tobias

    Thread Starter lamberbee

    (@lamberbee)

    Hey Tobias,

    Thanks for the quick reply.
    Maybe a suggestion: include a parameter in the import admin page when you can set the number of columns to import.

    Regards,
    Lambert

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for the suggestion, but I think that that could be rather confusing. I don’t really want to make that already cluttered interface (with source, format, etc.) more complicated.

    Regards,
    Tobias

    Thread Starter lamberbee

    (@lamberbee)

    Don’t think so but OK, no problem.
    Could you help on my way in THE code where the actual Excel import happens. Maybe I can build something myself

    Thanks

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    the Excel import is the libraries/excel-reader.class.php. That’s where you might find something. Unfortunately, as that code was not written by me, I’m probably not really going to be able to help with details ??

    Just to double-check: Have you tried the CSV export from Excel and then importing that? That should work better and might save you all this extra work.

    Regards,
    Tobias

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Import table via XLS, limit number of columns’ is closed to new replies.