Cancel
Showing results for 
Search instead for 
Did you mean: 

Export more table files to one excel

Solution Partner Pioneer Solution Partner Pioneer
Solution Partner Pioneer

Hello guys!

 

I want to export 2 TableFile into the 1 Excel file. Each Tablefile should be in different sheet.

 

I have this code:

tab1.writeexcelfile(C:\Users\Technomatix\Desktop/PS/TEST,"TAB1")

tab2.writeexcelfile(C:\Users\Technomatix\Desktop/PS/TEST,"TAB2")

 

My second line will create new excel and delete the first one.

 

Thank you Smiley Happy

4 REPLIES

Re: Export more table files to one excel

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

do you have the inferface package?

Steffen Bangsow
freelance simulation specialist  
web: www.bangsow.eu
mail: steffen@bangsow.net

Re: Export more table files to one excel

Solution Partner Pioneer Solution Partner Pioneer
Solution Partner Pioneer

Yes I have

Re: Export more table files to one excel

Solution Partner Pioneer Solution Partner Pioneer
Solution Partner Pioneer

Its working now, I changed the "/" to "\" is command :-D 

thank you anyway Smiley Happy

Betreff: Export more table files to one excel

Siemens Phenom Siemens Phenom
Siemens Phenom

I'd recommend to add the file extension .xlsx:

tab1.writeexcelfile("C:\Users\Technomatix\Desktop/PS/TEST.xlsx","TAB1")

tab2.writeexcelfile("C:\Users\Technomatix\Desktop/PS/TEST.xlsx","TAB2")

This way Excel knows what format to use.

 

Regards,

Ralf
------------------------------------------------------------------------------------------------------
Did you like the answer? Then click the Thumbs Up button.
Did the answer solve your problem? Then accept the answer as solution.