search

zeinasaleh / sqlsheet

Automatically exported from code.google.com/p/sqlsheet
0 stars 0 forks source link

Closing connection causes file corruption #2

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
https://groups.google.com/forum/?fromgroups#!topic/scriptella/wr_dkDaQsKQ

Sometimes after reading a spreadsheet, after all of the statements have been 
executed and it attempts to close the connection on the xls driver, it seems 
like it rewrites the entire xls file? I have noticed at times the file size 
will shrink which I assume is due to a difference in compression in how the 
sheet is being saved as; but the big issue here is that if anything happens 
during this period, or if there is an exception during the processing phase, 
the context is not closed properly and the xls file is basically truncated and 
you're left with a spreadsheet that has 0 bytes. Is the only way to avoid this 
making all of the source files read-only?

Original issue reported on code.google.com by vasilievip on 30 Apr 2012 at 9:49

GoogleCodeExporter commented 8 years ago 
This issue was closed by revision r82.

Original comment by vasilievip on 30 Apr 2012 at 9:54

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago

Original comment by vasilievip on 27 Apr 2013 at 7:04