Values being formatted differently when opening spreadsheet using ado.net
 

I have a some-what simple app for importing data from excel to our database.
The app is written in C# and uses ado.net.

When I open the xls file, it displays in a grid to show the values.

The problem is values are formatted differently depending on the machine.

I have 2 machines. One the first one (excel installed) I open the xls file
and all values display as decimal even though in excel there displayed as
percents. This is fine and how I want it.
On the second machine (excel not installed) the values display as percents.

What can cause the difference in formatting?

Thanks,
Joe

Values being formatted differently when opening spreadsheet using ado.net
 

Joe wrote:
I open the xls file
and all values display as decimal even though in excel there
displayed as
percents.

How are you opening the xls file without Excel? Using a viewer?
ADO.NET?

Jamie.

--

Values being formatted differently when opening spreadsheet using ado.net
 

I'm opening it in a DataGrid.

"onedaywhen" wrote in message
oups.com...

Joe wrote:
I open the xls file
and all values display as decimal even though in excel there
displayed as
percents.

How are you opening the xls file without Excel? Using a viewer?
ADO.NET?

Jamie.

--

Values being formatted differently when opening spreadsheet using ado.net
 

Joe wrote:
How are you opening the xls file without Excel? Using a viewer?
ADO.NET?

I'm opening it in a DataGrid.

You may be showing it in a gid but how are you accessing the data in
the xls: ADO.NET, COM automation, etc? Posting some code may help us.

Jamie.

--