Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

how to open Excel,

and that the cell's styling will be Number with no numbers after the dot (.)

for example: the number 1234567890 will show 1234567890 not 1.23E+09

thank's in advance

share|improve this question

migrated from Dec 31 '09 at 1:10

This question came from our site for professional and enthusiast programmers.

If the number format of the cells are correctly set already, you can do this using the AutoFit command.

Worksheet worksheet = (Worksheet)workbook.ActiveSheet;
Range usedRange = worksheet.UsedRange;

Have a look here

How to automate Microsoft Excel from Microsoft Visual C# .NET

share|improve this answer
thank's for the help, but it do nothing – Gold Dec 29 '09 at 15:52

you can read excel file like an access database with OleDB. then you can fill data into DataTable and work with it.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .