Read excel file from PDA device(compact framework)

Question

0.00/5 (No votes)

See more:

Hello everyone,

I have a PDA device (Windows Mobile 6.5) in which I am building an application in C# using Visual Studio 2008(Compact Framework 3.5). Part of this application requires reading some data from excel file in order to add them to a report. I tried many of the framework suggestions I read online, but nothing seems to be suitable.

Does anybody know how to either:
1)Convert the .xlsx file to .csv so that I can read it with Filestream & StreamReader, or
2)Find the assemblies for Excel Data Reader or ByteScout Spreadsheet SDK (they both claim to have dll for Compact Framework but I can't find them anywhere) or
3)Any other way I can read excel files from the device(I don't need to process the file, only to get the data)?

I know similar questions have been asked before but I tried many different things and nothing worked properly. Any help or suggestions would be valuable.

Thank you in advance.

What I have tried:

CsvHelper,Excel Data Reader,FileStream,ByteScout Spreadsheet SDK

Posted 10-Jul-19 4:41am

anastasia_

Updated 10-Jul-19 5:36am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MadMyche · Answer 1 · 2019-07-10T05:36:00

Solution 1

How about this: .NET Library that Read/Write Excel Spreadsheet – Exploring the World[^]

Posted 10-Jul-19 5:36am

MadMyche

Comments

anastasia_ 11-Jul-19 2:58am

I forgot to mention, I tried this library as well but when I load the file I get the "DivideByZeroException". I cannot understand how can this exception be thrown by opening a file. Do you have any idea of what causes this error?

This is the code i use to open the file:

string file = "\\My Documents\\Business\\excel_test.xlsx";
Workbook workbook = Workbook.Load(file);

MadMyche 11-Jul-19 9:43am

I know little about Compact Framework and nothing about your file, so really cannot help you with the problem. It would be much easier to work with CSV as it is does not require special readers

anastasia_ 11-Jul-19 9:52am

I cannot store the file in the PDA in .csv form,because it it imported from an other device(a machine that produces reports and is able to export them in excel form). I tried converting the files from .xlsx to .csv in the device but so far without success. Nevertheless, thank you for answering me!