B4J Question How to use jexcel to read a xls file and write a text file?

[ciprian]

Hello. I have this xls file to read, with the exemple provided by you. I wish to read it and write a text file with the text i can find into the xls file.
How can i store text from a case, and use it to write a text file?

Here is my xls file.

Thank you

 

[Erel]

You should follow this example: http://www.b4x.com/android/forum/threads/jexcel-library.35004/

Instead of adding the items to a table write them to a file. You can use StringUtils.WriteCSV to write them as a CSV file.

 

[ciprian]

This is what i'm trying to do, but when i di a Log(), the text seems coded, or i dont know

 

[Erel]

Can you post the relevant code?

 

[ciprian]

Here it is.

 

[Erel]

Where is the code that is supposed to save the data to a file?

 

[ciprian]

I should do something like this :

Dim lines As List
lines.Initialize
lines.Add(" A0")
lines.Add(" A1)
lines.Add(" A2")
lines.Add(" B0")
lines.Add(" B1)
lines.Add(" B2")
File.WriteList(File.DirApp, "excel.txt", lines)

 

[Erel]

The list in ValuesAvailable is a list of arrays.

To get cell A2 you need:

Dim row() As String = List.Get(0)
Log(row(1))

 

[ciprian]

thank you EREL. I wil follow your way

 

[ciprian]

this is ok, it works.
But when i open a xls file, i have this error :

Program started.
log4net:ERROR XmlHierarchyConfigurator: Could not create Appender [XpClient] of type [log4net.Appender.RollingFileAppender,log4net]. Reported error follows.
System.IO.FileNotFoundException: Impossible de charger le fichier ou l'assembly 'log4net' ou une de ses d‚pendances. Le fichier sp‚cifi‚ est introuvable.
Nom du fichierÿ: 'log4net'
… System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
… System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
… System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
… System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)
… log4net.Util.SystemInfo.GetTypeFromString(Assembly relativeAssembly, String typeName, Boolean throwOnError, Boolean ignoreCase)
… log4net.Repository.Hierarchy.XmlHierarchyConfigurator.ParseAppender(XmlElement appenderElement)
AVTÿ: le journal de liaison d'assembly est d‚sactiv‚.
Pour activer le journal des ‚checs de liaison d'assembly, attribuez la valeur 1 … la valeur de Registre [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD).
Remarqueÿ: une certaine perte de performance est associ‚e … l'enregistrement dans le journal des ‚checs de liaison d'assembly.
Pour d‚sactiver cette fonctionnalit‚, supprimez la valeur de Registre [HKLM\Software\Microsoft\Fusion!EnableLog].
log4net:ERROR XmlHierarchyConfigurator: Appender named [XpClient] not found.
log4net:ERROR XmlHierarchyConfigurator: Could not create Appender [XpClient] of type [log4net.Appender.RollingFileAppender,log4net]. Reported error follows.
System.IO.FileNotFoundException: Impossible de charger le fichier ou l'assembly 'log4net' ou une de ses d‚pendances. Le fichier sp‚cifi‚ est introuvable.
Nom du fichierÿ: 'log4net'
… System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
… System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
… System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
… System.Type.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase)
… log4net.Util.SystemInfo.GetTypeFromString(Assembly relativeAssembly, String typeName, Boolean throwOnError, Boolean ignoreCase)
… log4net.Repository.Hierarchy.XmlHierarchyConfigurator.ParseAppender(XmlElement appenderElement)
AVTÿ: le journal de liaison d'assembly est d‚sactiv‚.
Pour activer le journal des ‚checs de liaison d'assembly, attribuez la valeur 1 … la valeur de Registre [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD).
Remarqueÿ: une certaine perte de performance est associ‚e … l'enregistrement dans le journal des ‚checs de liaison d'assembly.
Pour d‚sactiver cette fonctionnalit‚, supprimez la valeur de Registre [HKLM\Software\Microsoft\Fusion!EnableLog].
log4net:ERROR XmlHierarchyConfigurator: Appender named [XpClient] not found.

 

[Erel]

Do you get this error in the IDE logs?

 

[ciprian]

Yes, but i'm having a bad internet connection so i couldn't insert into the "code" marks.

 

[Erel]

Does the program crash? This error message doesn't look related to your program.

 

[ciprian]

the program works corectly. this error appears when i click onto the OPEN FILE button.

 

[Erel]

Not sure where do these messages come from.

It seems to open the file successfully:

 

[ciprian]

ok, it seems to be from my HKLM registry, on my PC