misbehaved import from .xlsx

Resolved allamsarraf
(@allamsarraf)

3 years, 1 month ago
Dear Tobias,

after i updated to Version 2.1.1 i noticed a glitch happening when importing from .xlsx its a big table with links inside .. unfortunately the import is successful but the links are imported with adding a “\” .. its been long time i import and export with no issue .. i will post example .. thank you

excel file cell contains : <a href=”/bccl/Documents/2022/2022M8.pdf” target=”_blank” rel=”noopener”>Ar</a>

after import the table cell contains :
```
<a href=\"/bccl/Documents/2022/2022M8.pdf\" target=\"_blank\" rel=\"noopener\">Ar</a>
```
which makes the link for to work properly

The page I need help with: [log in to see the link]

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

Plugin Author Tobias Bäthge
(@tobiasbg)

3 years, 1 month ago

Hi,

thanks for your post, and sorry for the trouble.

Just to rule out that this is not caused by other things on the site, can you please test if this also happens when importing that .xlsx on a (free) test site via https://tablepress.org/demo/#try ? Thanks!

Regards,
Tobias

Thread Starter allamsarraf
(@allamsarraf)

3 years, 1 month ago

Thank you Very Much , i tried the test site , same issue it still adding a “\”

i posted a screenshot.

https://ibb.co/cxKpvqD

Thread Starter allamsarraf
(@allamsarraf)

3 years, 1 month ago

sorry to trouble , i noticed it is adding a backslash before every quote

Plugin Author Tobias Bäthge
(@tobiasbg)

3 years, 1 month ago

Hi,

that’s really weird and should not happen, normally… Can you maybe send me that .xlsx file by email (the address is on https://tablepress.org/impressum/ ) so that I can run a few tests with it? Thanks!

Regards,
Tobias

Thread Starter allamsarraf
(@allamsarraf)

3 years, 1 month ago

Yes sure , i sent the file to [email protected]

subject : misbehaving Import from xlsx

sender: [email protected]

Many Thanks

Plugin Author Tobias Bäthge
(@tobiasbg)

3 years, 1 month ago

Hi,

thanks for the sending me the file! I can confirm the problem.

From what I can see, this is related to the cell type of the content. For the cells with that link HTML code, this is set to “Text”, which seems to cause this. I will investigate this in the code, to see if special handling is needed.

In the meantime, I see two possible workarounds: Either change the cell type of these cells from “Text” to “Default” (or “Standard”). Or, save the table to a CSV file in Excel and then import the .csv file into TablePress. This should then properly import the HTML code.

Regards,
Tobias

Thread Starter allamsarraf
(@allamsarraf)

3 years, 1 month ago

Hi,

thank you the the immediate help , i will try the workaround you provided by tomorrow and get back with results .. but kinda weird it was working like charm on all versions of earlier tablepress verions.

Best regards.

Plugin Author Tobias Bäthge
(@tobiasbg)

3 years, 1 month ago

Hi,

yes, please let me know how things go!

Now, this is not that “weird” actually 🙂 Starting with version 2.0, TablePress uses a different (and more modern) code library for importing Excel files. This brings improvements in many areas, but unfortunately, there might be a few changes compared to old behavior — and reports like yours help me find those. So, thanks for reporting this problem! 🙂

Best wishes,
Tobias

Thread Starter allamsarraf
(@allamsarraf)

3 years, 1 month ago

Hi Tobias,

thank you for your reply . Putting the columns where the url links reside to “Standard” cells worked perfectly .. i am just fine with this solution .. thank you very much for your great help ..

Regards.

Plugin Author Tobias Bäthge
(@tobiasbg)

3 years, 1 month ago

Hi,

no problem, you are very welcome! 🙂 Good to hear that this helped!

Best wishes,
Tobias

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

The topic ‘misbehaved import from .xlsx’ is closed to new replies.