The limit of 256 columns is in Excel 2003 xls files, not EpiData. If you have a more recent version of Excel, you can export from EpiData to a text file, then import that text file into an Excel xlsx file (which allows for more than 256 columns).
-----Original Message----- From: epidata-list-bounces@lists.umanitoba.ca [mailto:epidata-list-bounces@lists.umanitoba.ca] On Behalf Of epidata-list@lists.umanitoba.ca Sent: Thursday, August 11, 2011 11:16 AM To: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] Export EpiData to Excel - is there a solution/analternative?
Hey Jamie,
thank you very much! I tried to suggest that to my boss but she is not convinced yet. Are there any other possibilities available?
Thanks and greetings, Nina
Am 11.08.2011 16:49, schrieb epidata-list@lists.umanitoba.ca:
Go ahead and export the data. EpiData will make a spreadsheet with
more than 256 columns. I just exported one with 501 columns. You can open it in OpenOffice (www.openoffice.org). OpenOffice allows 1024 columns.
Jamie
On 2011-08-11, Nina-Claire wrote:
The data I want to export to Excel consists of approximately 960
lines in Epidata formats (= 960 colums in .xls). As I understand EpiData (and as the test with the used data showed) it is impossible to export more than 256 lines to Excel (version 2003) because of the Excel 2003 column limit . Is there any way to export the 960 lines to Excel? Or is there another alternative I should consider?
EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
_______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list