Re^6: Problem using SaveAs when trying to change Excel format

OP as in ... i should have done it like below :

$Book->SaveAs($file_name) ???
[download]

Though this also isn't of any help. i have already tried it. I'm stuck here...don't know how to proceed here. Kindly help!!!

Comment on Re^6: Problem using SaveAs when trying to change Excel format Download Code

Replies are listed 'Best First'.
Re^7: Problem using SaveAs when trying to change Excel format by Ratazong (Monsignor) on Jul 09, 2014 at 12:54 UTC
`$Book->SaveAs($file_name);` works for me, unless the file `$file_name` is already existing. I usually solve that problem by trying to delete the file before overwriting it. If `SaveAs()` is still not working, verify the path (and try both, slashes and backslashes - excel seems to be a bit picky about them) HTH, Rata	[reply] [d/l] [select]
Re^8: Problem using SaveAs when trying to change Excel format by Anonymous Monk on Jul 09, 2014 at 13:07 UTC
Hi Rata, I'm very thankful for your help ( :) ) but I want to edit the $file_name and want to save the changes in the same file.	[reply]
Re^9: Problem using SaveAs when trying to change Excel format by Ratazong (Monsignor) on Jul 09, 2014 at 13:46 UTC
To edit a file, use `$book->Save();` instead of `$book->SaveAs($filename);` HTH, Rata	[reply] [d/l] [select]
Re^9: Problem using SaveAs when trying to change Excel format by Anonymous Monk on Jul 09, 2014 at 13:09 UTC
Also slashes and backslashes, both are not working in my case.	[reply]