MathNya / umya-spreadsheet

A pure rust library for reading and writing spreadsheet files
MIT License
238 stars 41 forks source link

How to quickly write millions of data #182

Closed shijunti19 closed 4 months ago

shijunti19 commented 4 months ago

The current method seems too slow I want to create a new Excel file and write 1 million data lines by lines. How should I write code. How can we do it the fastest

image 32 seconds is too long

Is there a way to add line by line For example: file_put_contents ("", FILE-APPEND);

or

let row_index = 0; let values: Vec<&str> = vec!["Value 1", "Value 2", "Value 3", "Value 4"]; worksheet.add_row_string(row_index, &values);