Question 1

How to export huge datasets in Laravel without memory errors?

Accepted Answer

Use generators with Fast Excel's chunked export feature. Define a function that yields rows from a database cursor, then pass it to FastExcel to stream data and avoid memory limits, as shown in the README's usersGenerator example.

Question 2

Can I import CSV files with different delimiters like semicolons?

Accepted Answer

Yes, use the configureCsv method to set custom delimiter, enclosure, and encoding. For example, (new FastExcel)->configureCsv(';', '#', 'gbk')->import('file.csv') handles CSV with semicolon delimiter and GBK encoding.

Question 3

Fast Excel or Laravel Excel: which is better for my project?

Accepted Answer

Pick Fast Excel for high-performance, low-memory tasks with basic import/export needs. Choose Laravel Excel if you need advanced features like charts, formulas, or extensive styling, but be prepared for higher resource usage.

Question 4

How to add styles like bold headers in Fast Excel exports?

Accepted Answer

Use the headerStyle and rowsStyle methods with Spout's Style class. Create style objects, set properties like font bold or background color, and chain them in the export call, as detailed in the advanced usage section.

Question 5

Does Fast Excel support importing specific sheets from a multi-sheet Excel file?

Accepted Answer

Yes, use the sheet method to target a sheet by number. For instance, (new FastExcel)->sheet(3)->import('file.xlsx') imports only the third sheet, allowing selective data processing.

Question 6

What file formats can Fast Excel handle for exports?

Accepted Answer

It supports .xlsx, .ods, and .csv formats, leveraging the Spout library. Older .xls format is not supported, so ensure your files are in one of these compatible formats for seamless operation.

Fast Excel

What is Fast Excel?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Open Source Alternative To

Frequently Asked Questions