fastexcel | Generate and read big Excel files | Data Visualization library

by dhatim Java Version: 0.15.4 License: Non-SPDX

X-Ray Key Features Code Snippets Community Discussions(6)Vulnerabilities Install Support

kandi X-RAY | fastexcel Summary

fastexcel is a Java library typically used in Analytics, Data Visualization applications. fastexcel has no bugs, it has no vulnerabilities, it has build file available and it has low support. However fastexcel has a Non-SPDX License. You can download it from GitHub, Maven.

There are not many alternatives when you have to generate xlsx Excel workbooks in Java. The most popular one ([Apache POI] includes many features, but when it comes down to huge worksheets it quickly becomes a memory hog. Its streaming API may mitigate this problem but it introduces several limitations: - Its sliding window mechanism prevents you from accessing cells above the current writing position. - It writes stuff to a temporary file. - It comes with an overhead on the file size because shared strings are disabled by default. Enabling shared strings is likely to consume much more heap if you deal with string values. So, fastexcel has been created to offer an alternative with the following key points: - Limited set of features (basic style support, no graph support yet) and very simple API. - Reduced memory footprint and high performance by accumulating only necessary elements. XML stuff is piped to the output stream at the end. - Multithreading support: each worksheet in the workbook can be generated by a different thread, while fully supporting shared strings and styles.

Support

Quality

Security

License

Reuse

Support

fastexcel has a low active ecosystem.

It has 492 star(s) with 82 fork(s). There are 26 watchers for this library.

It had no major release in the last 12 months.

There are 31 open issues and 87 have been closed. On average issues are closed in 131 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of fastexcel is 0.15.4

Quality

fastexcel has 0 bugs and 0 code smells.

Security

fastexcel has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

fastexcel code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

fastexcel has a Non-SPDX License.

Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

Reuse

fastexcel releases are available to install and integrate.

Deployable package is available in Maven.

Build file is available. You can build the component from source.

Installation instructions are not available. Examples and code snippets are available.

It has 5231 lines of code, 518 functions and 70 files.

It has medium code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed fastexcel and discovered the below as its top functions. This is intended to give you an instant insight into fastexcel implemented functionality, and help decide if they suit your requirements.

Finishes the workbook generation
Finish the workbook
Flush all rows currently in the workbook
Writes the workbook to a zip file
Sets the conditional formatting rule
Returns the cell at the given coordinates
Apply this style
Returns the cell at the given coordinates
Set header text
Sets the header text
Compares this range with another
Set footer text
Parse the workbook
Writes the VML drawing to the specified writer
Returns a string representation of this address
Returns a string representation of this component
Checks if this style object equals another object
Write the cache as XML
Compares this border with another
Returns true if this object equals another
Reads ID of workbook parts from a XML file
Create a single sheet
Extract part entries from XML
Extract format string from style
Appends comments to the given writer
Write this style cache as XML
Creates a new worksheet

Get all kandi verified functions for this library.

fastexcel Key Features

No Key Features are available at this moment for fastexcel.

fastexcel Examples and Code Snippets

No Code Snippets are available at this moment for fastexcel.

Community Discussions

Trending Discussions on fastexcel

Apache POI Large Excel Export is slow

Query takes to much time to execute laravel

How to get worksheet name using Fastexcel in Laravel

Excel whole column reference in array formula too slow, not respecting UsedRange?

Prevent recalculations of User Defined Functions used in named ranges

How to export data of array to excel with each element from an array storing in single row

QUESTION

Apache POI Large Excel Export is slow

Asked 2021-Nov-14 at 16:37

I am trying to convert CSV to Excel with Apache POI by using SXSSFWorkbook.

My CSV file has about 230,000 records and 50 columns. Total processing time for both read and write processes around 1 minute.

I am looking around to solve my performance issue to get lower times (max. 30 sec) since the connection time out occurs after 30 sec. from gateway.

What am I doing wrong? Is there anything I could change?

...

ANSWER

Answered 2021-Nov-14 at 16:37

There is no problem with the way you write to Excel. Time is mainly wasted on the method of reading CSV. In addition, fastexcel is the best choice I tested, it is faster than others( SXSSFWorkBook ,easyexcel and myexcel).The following code hopes to be useful to you.

Source https://stackoverflow.com/questions/69914445

QUESTION

Query takes to much time to execute laravel

Asked 2021-Nov-14 at 09:39

I m uploading an excel file, which contains User data with their products status (0,1).

I want to do save the product data in Productsale table first, with user_id, product_id,target_month, and status.

then I get all users and then get product and its status from productsale table and count it and save its result in Saleproduct table.

I have 33000 rows in the excel file and saving 300k in productsale, boz everyuser have 8 products,

here is the SS of excel

here is my code

...

ANSWER

Answered 2021-Nov-14 at 06:55

If it takes too long to run (and presumably results in an error being returned) then don't do it synchronously - ie. whilst the user is waiting - but to it asynchronously.

Your controller should just be concerned with validating the file, saving it into storage, and returning the success code to the user to tell them that the file has been uploaded, and will be processed shortly.

Then move all the code about the processing of the file into a job, which the controller dispatches, which runs in the background. Ideally this would be on a queue (in which case look at your queue settings, as the default is 30 seconds for the job to finish there, which lines up with the PHP settings you are probably falling foul of already, so be prepared to allow a longer time for the job to execute).

Source https://stackoverflow.com/questions/69960852

QUESTION

How to get worksheet name using Fastexcel in Laravel

Asked 2020-Aug-12 at 03:39

I am using FastExcel in Lumen for importing data from excel sheet to database.

...

ANSWER

Answered 2020-Aug-12 at 03:39

Currently, there is no way to get the sheet name(names). The PHP library does not support it.

If you want to import a specific sheet, there is no native way to do it. You may try some of the options down below.

You know the sheet number.

Source https://stackoverflow.com/questions/63369053

QUESTION

Excel whole column reference in array formula too slow, not respecting UsedRange?

Asked 2020-May-31 at 08:22

I have a worksheet with many array formulas referencing another small source data sheet with a couple of rows. Formulas are as follows:

...

ANSWER

Answered 2020-May-31 at 08:20

Not sure if you are building this through VBA but if it's just formulas you are using you could try something like:

Source https://stackoverflow.com/questions/62112792

QUESTION

Prevent recalculations of User Defined Functions used in named ranges

Asked 2020-May-30 at 18:53

I have three UDF's:

...

ANSWER

Answered 2020-May-30 at 08:37

You should be able to prevent unnecessary additional calculations by including

Source https://stackoverflow.com/questions/62099812

QUESTION

How to export data of array to excel with each element from an array storing in single row

Asked 2020-Jan-21 at 17:01

I am trying to export data to excel using Fast excel. This is easy for straight forward export. However, I have data as follows:

...

ANSWER

Answered 2020-Jan-21 at 14:18

public function exportTest() {

        $reviews = DB::table('test_db')->orderBy('name')->get();

        $file_name = 'Review - '.date('Y_m_d').'.xlsx';

        return (new FastExcel($reviews))->download($file_name,function($reviews) {

            foreach ($reviews as $review) {
                # code...
                if(!empty($review->multiple_units)) {

                    $unit_ids = json_decode($review->multiple_units, true);

                    foreach($unit_ids as $uk => $uv){
                        return [
                            'Name' => $review->name,
                            'Units' => $uv
                        ];
                    }

                }
            }

        });
    }

Source https://stackoverflow.com/questions/59719899

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install fastexcel

You can download it from GitHub, Maven.
You can use fastexcel like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the fastexcel component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: