tag:blogger.com,1999:blog-684183198890094283.post5658168550784726613..comments2023-11-05T06:12:59.718-05:00Comments on S.Lott-Software Architect: .xlsm and .xlsx Files -- Finally Reaching Broad UseS.Lotthttp://www.blogger.com/profile/06337323642834330176noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-684183198890094283.post-22705758024898783122012-06-20T01:00:59.543-04:002012-06-20T01:00:59.543-04:00Quan Ho, you have not got a brainQuan Ho, you have not got a brainAnonymoushttps://www.blogger.com/profile/04419447273635246395noreply@blogger.comtag:blogger.com,1999:blog-684183198890094283.post-56394363228432994392012-06-04T11:46:16.764-04:002012-06-04T11:46:16.764-04:00Can you convert the code to JavaScript?Can you convert the code to JavaScript?Quan Hohttps://www.blogger.com/profile/14768894742243601306noreply@blogger.comtag:blogger.com,1999:blog-684183198890094283.post-23880601596826366982012-03-05T10:15:17.216-05:002012-03-05T10:15:17.216-05:00Hi,
This is a very useful example of how covert hu...Hi,<br />This is a very useful example of how covert huge xlsn files to csv using Sax. <br /><br />Thanks for sharing.Anonymoushttps://www.blogger.com/profile/16820665972273766215noreply@blogger.comtag:blogger.com,1999:blog-684183198890094283.post-72104848680465254702011-12-06T11:23:39.355-05:002011-12-06T11:23:39.355-05:00Hi,
Very useful. I didn't know that I could u...Hi,<br /><br />Very useful. I didn't know that I could unzip an excel file :)<br /><br />One thing i noticed though, the code doesn't write the last column to the CSV.<br /><br />you need to change the line in GetSheetData.endElementNS(self, name, qname): <br />...<br />...<br />self.writer.writerow( [ self.row.get(i) for i in xrange(max(self.row.keys())+1) ] )amuhsenhttps://www.blogger.com/profile/04997568619163076150noreply@blogger.comtag:blogger.com,1999:blog-684183198890094283.post-12996620188647796382010-10-04T18:51:06.258-04:002010-10-04T18:51:06.258-04:00Umm, good article but...
You state: "Spreads...Umm, good article but...<br /><br />You state: "Spreadsheets are -- BTW -- the universal user interface. Everyone likes them, they're almost inescapable. And they work."<br /><br />Unfortunately they don't work. Some auditors such as KPMG say that around 95% of the spreadsheets they audit have errors. It is notoriousely difficult to both audit spreadsheets, and to spot changes/errors. <br /><br />I would agree that spreadsheets are heavily used, but the error rate seems to be high, in critical documents submitted in important tax claims.<br /><br />See <a href="http://staffweb.cms.gre.ac.uk/~cd02/EUSPRIG/" rel="nofollow">http://staffweb.cms.gre.ac.uk/~cd02/EUSPRIG/</a>Paddy3118https://www.blogger.com/profile/06899509753521482267noreply@blogger.comtag:blogger.com,1999:blog-684183198890094283.post-90804752499936361852010-10-04T11:12:16.217-04:002010-10-04T11:12:16.217-04:00Hi
You know you could use elementtree to do this ...Hi<br /><br />You know you could use elementtree to do this processing. Elementtree can do pull style processing see http://effbot.org/zone/element-pull.htm or use iterparse http://effbot.org/zone/element-iterparse.htmTimhttps://www.blogger.com/profile/13598533839142653366noreply@blogger.com