Fellow teachers, ask a question: if there are hundreds of thousands of recorded data table, how to translate into digital watch? Electronic record capacity is not so much how to do?

CodePudding user response:

The EXCEL worksheets (Sheet) can be used up and saw a usage is a Sheet of article 2000, 20000, you can't can also be multiple workbook (XLS file)

CodePudding user response:

More than 560000 records points workbook don't get dizzy

CodePudding user response:

Work the rows in the table is limited, this is no way to ah

CodePudding user response:

reference liups reply: 3/f

work the rows in the table is limited, this is no way to

EXCEL table row and column is the maximum quantity limitation, the old version is more than 60000 lines, 256 columns, the new version has 1.04 million rows and 160000 columns,
The above is the Internet, maybe you can consider the new version of the file (XLSX)

CodePudding user response:

The new version is not working, we pack is 2003 version compatible version

CodePudding user response:

The new version of excel is a good way to solve,

CodePudding user response:

After installed the new version, transforming FOXRPO6.0 data tables have turned

CodePudding user response:

Save in multiple worksheet in a workbook

CodePudding user response:

A workbook EXCEL2003 can create 255 jobs in the table

CodePudding user response:

Guide the CSV format, again into excel XLSX format,