How to get excel values into WinForm App/ C++ CLI?

Question

0.00/5 (No votes)

See more:

VS2010

Hello mates,

in my testing program, I'm going to get values from an excel file into my windows forms appilication under C++CLI/CLR.

The excel file looks like this:

No.  peronal Number     Name    Age   Height   other info
1    1001               Tom     10    153cm    ...
2    1105               Jack    11    158cm    ...
3    1320               Ben     13    160cm    ...
.                       .       .     .        .
.                       .       .     .        .
.                       .       .     .        .
100  1213               George  12    162cm    ...

The informations of the children should be showed after I give the number 1...100 in a textBox and click a button1. For example, when I give a "3" into the textBox,
and click button1, then the info of Ben should be showed on my windows form.

As far as I've serched in the internet. It should be handled with use of OleDb or ADO or namespace "Microsoft::Office::Interop::Excel". I've choosed the "Microsoft::Office::Interop::Excel". But I don't know how to get values from a exited xls-file.
I coded this to open an excel file on my windows form:

C#

using namespace Microsoft::Office::Interop::Excel;

#define Excel Microsoft::Office::Interop::Excel
.
.
.
Excel::Application^ xlApp =gcnew Excel::ApplicationClass();
				 
Excel::Workbook^ mybook = xlApp->Workbooks->Open("C:\\test.xlsx",Type::Missing, Type::Missing, Type::Missing, Type::Missing, Type::Missing, Type::Missing, Type::Missing,Type::Missing, Type::Missing, Type::Missing, Type::Missing, Type::Missing,Type::Missing, Type::Missing);
				 
xlApp->Visible = true;

This works well. I think now I need to use the WorkSheets->Cell[ ][ ] to get the values, or have I missunderstood it? Msdn doesn't give introductions for using this namespace detailly. Could you help?

And I have another question to the WinForm experts, a textBox question:

I've coded to limit the typing of textBox only with numbers and backspace.
But when I type "01" or "0021" etc. such numbers with one or more zeros as beginning,
it shows no error. But I want to make limit for that. How could I make it?

Thank you in advance!

Posted 8-Nov-12 21:53pm

christmars

Updated 9-Nov-12 2:36am

v4

Add a Solution

2 solutions

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)

Alexandre Bencz · Answer 1 · 2013-03-18T07:32:00

Use this tool: http://exceldatareader.codeplex.com/[^]

IT's extreme mor easy to read the excel file :)

to show the excel content, you can make this:

C#

DataTable excelTable = null;
IExcelDataReader excelReader = null;
try
{
    FileStream stream = File.Open(inputFileName, FileMode.Open, FileAccess.Read);
    if (Path.GetExtension(inputFileName).ToLower() == ".xls")
        excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
    else if (Path.GetExtension(inputFileName).ToLower() == ".xlsx")
        excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
    else
	    return;

    excelTable = excelReader.AsDataSet().Tables[0];
    if (excelTable == null || excelTable.Rows.Count == 0 || excelTable.Columns.Count == 0)
        throw new Exception("Error...");

    excelReader.Close();
}
catch (Exception ex)
{
    Console.WriteLine(ex.Message);
    return;
}

for (int i = 0; i < excelTable.Rows.Count; i++)
{
    for (int j = 0; j < excelTable.Columns.Count; j++)
    {
        Console.WriteLine(excelTable.Rows[i][j].ToString());
    }
}

Richard MacCutchan · Answer 2 · 2012-11-09T00:35:00

Some suggestions[^] about using Excel from C++/CLI. I cannot suggest which is the best but they should get you started with accessing the data.

As to limiting the content of a textbox, you need to have a delegate method that gets called on the entry of each character, which can validate the content. Take a look at the events in the textbox properties to decide which one to use.

How to get excel values into WinForm App/ C++ CLI?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0