Where to find the Base module of LibreOffice that has no row limit?
I have a file that has ten million rows. I want to open it using OpenOffice Calc but OpenOffice Calc 3.3.3 has a limit of around one million rows.
If you follow this link, the answer mentioned that the Base module of LibreOffice has NO ROW LIMIT.
Solution
LibreOffice Base can use Text files as the data source. Documentation is here: https://help.libreoffice.org/Common/Text_File_Connection.
To test this, the following python script produces a text file with ten million rows.
with open("datasource.txt", 'w') as f:
f.write("id,name\n")
TEN_MILLION = 10000000
for id_number in range(TEN_MILLION):
f.write("%d,abc\n" % id_number)
Open Base by going to File -> New -> Database in the LibreOffice menu. Then connect to an existing database.
Now, the "datasource" table can be viewed by opening it.
- Time Difference between query result rows in SQLite: How To?
- Python: Why randint on a matrix keeps giving me the same rows
- Does the space occupied by deleted rows get re-used?
- Equal height of elements inside grid item with CSS grid layout
- Update multiple rows with different values in a single SQL query
- Data Grid View...programmatically setting the select row index doesn't set the CurrentRow.Index to the same?
- SQL count rows in a table
- postgres execute sql in resulting rows
- Distribute Product Stock Qty. Table to Multiple rows of Order Table
- How to create new row out of calculation across other rows in Pandas Data Frame?
- Compare Python Pandas DataFrames for matching rows
- numpy padding matrix of different row size
- Python: Number of rows affected by cursor.execute("SELECT ...)
- Inserting Blank Rows in Excel VBA
- Fill Down values from a 1x6 array into an _x6 array Google App Script for Google Sheet
- pandas - change df.index from float64 to unicode or string
- vue.js v-for on two table rows
- adding rows with Nan values to Pandas DataFrame
- C# Linq rows to column
- Pivot Rows into column value
- Difference between rows based on a condition on R
- sql repeated date rows to columns on a new table
- percentage of cells to row total python
- SQL Number of rows
- Checking that ALL rows have met a certain criteria in a dataframe using iLoc
- Extracting rows from SQL query given a certain value
- How to make 1 rows from 2 rows which are entry and exit dates
- best way to generate rows based on other rows in pandas at a big file
- Split multiple columns into multiple new rows using condition R
- Collapse rows with overlapping ranges