Android Question Excel Library --> Initialize2(...) is not copying the original file contents into the new one

[Javier Campo Martinez]

Greetings!!!
i downloaded the Excel library, from this post:
Excel Library

I have a template file ... when i try to copy it into a new one, the new file does not contain the contents of the original.
This is the piece of code i am using, so far:

    Dim xlsEntrada As ReadableWorkbook
    xlsEntrada.Initialize(File.DirAssets,"PURCHASE_TEMPLATE.xls")
 
    Dim xlsSalida As WritableWorkbook
    Dim hojaArticulos As WritableSheet
    xlsSalida.Initialize2(File.DirRootExternal, "PURCHASEFILE.xls",xlsEntrada)
    hojaArticulos = xlsSalida.GetSheet(0)

    xlsSalida.Write
    ToastMessageShow("File generated.",True)

I attach a screenshot, both template and copied file.

Thanx in advance, any ideas will be appreciated !!!!

 

[Erel]

Copy the file to the PC and check it with the full Excel.

 

[Javier Campo Martinez]

Greetings !!!
I noticed the file is zero bytes size. I transferred it to my PC, I opened it with MS EXCEL, and it's empty. The name of the copied file is PURCHASE.xls, not PURCHASEFILE.xls (sorry for the typo error)

The EXCEL file has just one sheet, and no contents.

Looking forward for your comments.

 

[Javier Campo Martinez]

Solved. I forgot this line

xlsSalida.Close

after

xlsSalida.Write

 

[Javier Campo Martinez]

By the way, it's extremely easy to use. Thanks B4A team for providing us this awesome tool to develop.