Knowledgebase
Excel (XSL) importation with PHPExcel
Posted by Márcia Araújo on 01 October 2015 11:26 AM

In this article we will show how to create an application importing Excel spreadsheets (XLS) with the PHPExcel library

We had a seminar about this topic on 09/25/2015, the video can be found on the link below:

https://youtu.be/7383uLXeZhk

Please find the project with the codes are attached.

The Scriptcase has a tool for CSV files, ACCESS importaçãoconversão and XLS. This tool however is only available at the developer level, however it can't be implemented for the generated applications. It is possible to do this implementation manually within a field type upload, using its events in a form or control app. The implementation can be also made within an application blank, because it uses the PHPExcel library which has been imported into the Scriptcase.

 

For more information on Scriptcase import option for the development level we recommend the video:

https://youtu.be/EVlUZR-6zcM 

or documentation:

http://www.scriptcase.net/docs/en_us/v81/manual_mp.htm#tools/database-converter/overview



Attachments 
 
 sc8_bkp_xls_import_20151020-112738.zip (6.97 MB)
(13 vote(s))
Helpful
Not helpful

Comments (4)
Wilfred Lopez
28 October 2015 01:41 PM
Hello Marcia. I tried to restore the attached backup and displays a message : "The file was not created for version 8 Scriptcase ". Please your help !
Gustavo Veras Sampaio
01 March 2016 05:16 PM
Hello Wilfred Lopez, how are you?

This version of this backup should be restored in a version 8.1 of Scriptcase.

Any question, i'm available!
Ian Batey
22 April 2016 08:03 AM
I'm trying to restore in scriptcase 8.1.34 and I get the same message
Ronyan Alves
17 May 2016 03:22 PM
Please, try to restore by the option "File > Import project"
ScriptCase© - Todos os direitos reservados.
ERROR: This domain name (knowledge.netmake.com.br), does not match the domain name in the license key file suporte.scriptcase.com.br,support.scriptcase.net.

For assistance with your license, please contact the Kayako support team: https://support.kayako.com