Hi you all, I need to convert a .xls file in .csv file.
I would like to use libreoffice calc or numbers (if it is possible) for convert this file, using also automator.
Is it possible?
Many thanks you all.
MacBook Pro TouchBar and Touch ID, macOS Sierra (10.12.4)
Hi, I need to convert many xls files in csv, becouse Numbers has some troubles with them.
So, I vuole like to automatize this operation with Automator.
It is possible?
Thank you
Perhaps you can report back what you have tried with Automator
It do not work.
Numbers show the new .csv file so:
this is the original file 😉 https://we.tl/5og93vX3rl
When I open manually the original file with numbers I see the same thing.
Thank you.
Ok, many thanks 😉
Hi, HD,
Your code work perfectly 😉
Thank you!!!
Now I will open a new topic for import all csv file in tables in numbers automatically.
Only a question:
but this code do not update csv file, when I convert an update .html file?
Yes, it updates the .csv file if the new .html file has the same name as the old one. The old data in the .csv file is deleted by
set eoftext_writeto 0
H,
I think you'll end up using a few
"\""
in the replaces.
But maybe not too bad.
SG
Not as bad as I thought 😉
Hi, HD and SGII.
@HD: your code work perfectly for me 😉
Thank you for your help
How to convert .xls file into .csv without MS excel?
