Hello,

Please replace this folder “PhpSpreadsheet”. See the screenshot: https://ibb.co/dk05Ztb

Thank you so much

Thank you very much, good luck in your work and creativity!

Hello,

You can change column format. Please see the “basic-excel.php” page.

You add Number Format Code:

use PhpOffice\PhpSpreadsheet\Style\NumberFormat;

$spreadsheet->getActiveSheet()>getStyle(‘F’.$j)>getNumberFormat()->setFormatCode(NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);

$spreadsheet->getActiveSheet()>getStyle(‘F’.$j)>getNumberFormat()->setFormatCode(’#,##0’);

Thank you so much

Hey

Thanks for the great advice, it worked!

I went a little further and used the following code to remove spaces from the output:

$spreadsheet->getActiveSheet()>getStyle(‘D’.$j)>getNumberFormat()->setFormatCode(NumberFormat::FORMAT_NUMBER);

Please give me your email address.

Thank you so much

My email : udayana@ymail.com

I am asking about installing of non-Laravel version

Hello,

Please see the documentation or documentation video.

Thank you so much

I would not ask you if I know where is documentation for MySQL Data to Excel Export (before I buy it)

Hello,

Please give me your ftp access and site link. I will try this problem solve. My mail address tspprt7@gmail.com

Thank you so much

I found already the problem. I put one ; to many. Everything is working now.

Hello,

My script not support in WordPress.

Thank you so much

Hello,

You can export 4000 rows, Please try it demo link https://www.themeposh.xyz/data_export_limit/

Thanks

I don’t think you read my message correctly. let me send it again. What if i just want to pull a week data and not 4000 rows? this feature should be avaiable. add the date range and that should do it. can you add it?

Hello,

I sended multiple row grouping excel script file, Please check your yahoo mail.

Thanks

Hello,

If you want, can you give me your FTP access and your page link. I will try this problem solve. My mail address tspprt7@gmail.com

Thanks

Hello,

Please upload all files in your directory folder

Thanks

Hello,

Your problem solve. Properly not uploaded this folder ‘PhpSpreadsheet’. Please properly upload all files.

Thanks

No, normal excel file is export.

Hello,

I sended sub total excel export file, Please check your yahoo mail.

Thanks

Great, Thanks again

Hello,

If you want, can you give me your FTP access and your page link. I will try this problem solve. My mail address tspprt7@gmail.com

Thanks

ok

Hi, I sended the email, Could you check it?

I know how to change to 777 permissions via FTP but I don’t have a paid hosted server. I run WAMP on my computer with Windows OS so the folders should not be a problem. You can’t run CHMOD on Windows since its only for linux. Is there another way to do this since it looks like your script is only built for paid servers?

Hello,

Actually, my script is working on local and web hosting with paid and unpaid both server. I want to say for testing purpose, can you install xampp with PHP version 5.6 or newer in your Windows OS? Then run my script in xampp.

Thanks

Alright so I found the issue. First issue was that my SQL query was wrong so it returned zero value which was causing the problem we discussed before. However I think you should highlight the last line of code where you set your destination folder for the files. By default it’s set to “media/” and if you don’t have that folder already it will cause another error until you either change it or create a folder with that name.

Hello,

Sorry, I am give late your question answer. If you want, can you give me your FTP access. I will try this problem solve. My mail address tspprt7@gmail.com

Thanks

Hello,

Your hosting server directory folder has 777 permission.

Thanks

Yes my folder has 777 permissions , all the sub folders same If I close the conection with my database, can I open an Excel file

Hello,

For the generated excel file no need to database connection.

Thanks

Hello, You can’t write row data in your existing excel template. Here always created new excel with your mentioned column(s).

Thanks

Hello,

Any db file size upload, It’s possible. Need to increase memory size and execution time in your server. Please, you can follow the instruction from https://stackoverflow.com/questions/4895230/why-phpexcel-does-not-allow-to-write-more-than-5000-rows

Hello, There are allow to export only tabular data not able to export yet with image.

Thanks

Hello,

There are allow to Export all fields from the table, No able to select partial columns from table

Hello, There are no automated system. It’s simple Export tool. You are able to automated adding some extra code in this tool.

Thanks