Hi All,
I have been importing the same .xlsx file for the past two years without any problems. I keep updating the file, adding both rows and columns. Recently, I received the following error after entering more data:
I tried converting to .xls and .csv, both gave the same error. When I import the data manually (i.e. copy everything from the excel file and paste it into the data editor, it works fine). When I try to import using File > Import > Excel Spreadsheet, and select the file to be loaded, it only displays 256 columns. Currently, the file has 767 columns and 117 rows. The file size is 585 kb. I run Stata/IC 12.1 for Mac (64-bit Intel).
Why does Stata no longer import the file via the Excel data import? Has the maximum file size or column-width for imports been reached? Is there a away around it?
Looking forward to your answers.
Thank you so much.
I have been importing the same .xlsx file for the past two years without any problems. I keep updating the file, adding both rows and columns. Recently, I received the following error after entering more data:
. import excel "/Users/Rob/Documents/Participant data list_no format.xlsx", sheet("All_data") firstrow case(lower) clear
if invalid varname
exit(): 3300 argument out of range
import_excel_read_numcol(): - function returned error
import_excel_load_file(): - function returned error
import_excel_import_file(): - function returned error
<istmt>: - function returned error
r(3300);
if invalid varname
exit(): 3300 argument out of range
import_excel_read_numcol(): - function returned error
import_excel_load_file(): - function returned error
import_excel_import_file(): - function returned error
<istmt>: - function returned error
r(3300);
Why does Stata no longer import the file via the Excel data import? Has the maximum file size or column-width for imports been reached? Is there a away around it?
Looking forward to your answers.
Thank you so much.
Comment