Friday, June 8, 2012

Re: vim: what the current best practice to work with excel file (xlsx)?

thanks Eric,
I was trying to find out how to define my own delimiter (like a : or ; depending on which
one is not in the data itself) but no luck.
I'll login to a real windows machine with an EXCEL and try again.
b.t.w, space as a delimiter will need to face the same issue - the data might have spaces.

regards
ping

On 06/08/2012 10:24 AM, Erik Christiansen wrote:
On 08.06.12 09:45, ping wrote:  
I tried "save as" from excel into:    format                                 issue  =======================================================================  csv (comma delimited)                 some of my data contains comma  
  If cell data contains cell delimiters, can the saved file even be  re-imported into excel? i.e. It is corrupted data which is being saved,  AIUI. The few spreadsheets I've encountered (long ago, admittedly) allow  the cell delimiter to be set prior to saving the file. Can excel not do  that? (It's what I've repeatedly done in similar circumstances ... well,  actually asked others to do with their spreadsheets, before mining  the data with text tools. ISTR tab being used instead of comma.)      
formatted text(space delimited)         hard to align  
  An aligning plugin was named on this list in the last week or so, ISTR.  It might do the job?    
web page                              hard to render a framed page  
  That does seem like the long way there. :-)    Erik    

No comments: