KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

How to integrate excel importation and exportation #1560

Open TADIE Hervé opened this topic on on Aug 12, 2020 - 2 comments

TADIE Hervé commented on Aug 12, 2020

We are working with symfony 5.1.3 Then we start making our report using koolreport and it is really good Now we wanted to do excel importation - exportation We went on the examples and documentation but the part of code concerning that is nor describe ... So we need your help for a good description that can help us go ahead fast with our integration

Thanks.

David Winterburn commented on Aug 13, 2020

Hi,

Please copy and modify our Excel examples here:

https://www.koolreport.com/examples/reports/datasources/excel_report/

https://www.koolreport.com/examples/reports/excel/excel_template/

Let us know if you need any information. Thanks!

TADIE Hervé commented on Aug 25, 2020

Hello, thank for your help ... We need to get for each line of the excel file get the cell value or for each column get the cell value because we want to insert in our database.

For instance :

Our excel file (customer.xlsx) has 2 columns :

Code Name 001 TADIE 002 JIOGUE

And we have table customer in our database with same field

How do we :

  • Go through the excel as datasource ?
  • Go through each line or coloumn ?
  • Get cell value ?
  • Then Insert in the database table ?

I think if you answer or clarify for this example it could help us a lot

Thank

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None