Tag Info

Hot answers tagged

5

I take it you've got some values and you want to create a file that Excel can read. The easiest-to-create file format Excel understands probably is CSV, comma-separated values, i.e. a plain text file like this example (from Wikipedia): Year,Make,Model,Description,Price 1997,Ford,E350,"ac, abs, moon",3000.00 1999,Chevy,"Venture ""Extended ...


1

iozone -Rab output.wks will do both. The command will output the flat ascii formatted results for possible import by Excel ( space and tab delimited ) as well as generating the output.wks file, which is already in BIFF (Binary Interchange File Format). The output.wks file can be opened directly with Excel, and permits one to skip importing the flat ascii ...


1

You can probably tweak your Unix tools to handle the encoding correctly. However if you just want to strip the data before the ',' using Python: with open('Str.xls', 'w') as ofp: with open('Str.rc') as fp: for line in fp: ofp.write(line.split(',',1)[1]) If you want to run that from the commandline without saving it as a file first you ...


1

If you need to run the macros that are included/referenced in the .xlsm file on Linux then there is no software that I've come across or was able to find through searching that can do this. The major problem is that the underlying macro languages are completely different between MS Excel of LibreOffice. Without an application your next best options are to ...



Only top voted, non community-wiki answers of a minimum length are eligible