C# Excel 2010 programing

Question

I am writing a program in C# for analysing a structure details in an earth quake.I have a lot of data and want to put them in a excel file. I mean i need a function like this :

public void excel(int sheet_no,int row,int column,string value)

Is there any way to parse the text file and Put this data in Excel sheet ?

Extreeeemely vague. What are you trying to do, and what have you already done towards that end. — GrayFox374
– GrayFox374, Commented Jun 28, 2012 at 4:42
I have txt file with lots of numbers , over 1 milion detailed numbers , and want to put them in a excel file. that s all.How can i write them into excel file with C#? — Abadis
– Abadis, Commented Jun 28, 2012 at 4:46
Please have a look on following link: [ transfer data to an Excel workbook](support.microsoft.com/kb/306023) Convert the text file to Excel Format — Akash KC
– Akash KC, Commented Jun 28, 2012 at 5:00

M Rostami · Accepted Answer · 2012-06-30 13:39:40Z

2

use this :

Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Workbooks workbooks;
_Workbook workbook;
_Workbook workbook2;
Sheets sheets;
_Worksheet worksheet;
app.Visible = false;
workbooks = app.Workbooks;
workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
sheets = workbook.Worksheets;
worksheet = (_Worksheet)sheets.get_Item(1);
worksheet.Cells[row, column] = value;
workbook.Saved = true;
workbook.SaveAs(output_file);
app.UserControl = false;
app.Quit();

answered Jun 30, 2012 at 13:39

M Rostami

4,2051 gold badge39 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

nunespascal · Accepted Answer · 2012-06-28 04:55:53Z

2

Take a look at ClosedXml

Code sample:

var workbook = new XLWorkbook();
var worksheet = workbook.Worksheets.Add("Sample Sheet");
worksheet.Cell("A1").Value = "Hello World!";
workbook.SaveAs("HelloWorld.xlsx");

But if you are dealing with a lot of data, consider using a database like sqlserver. It provides a lot of analysis tools. You can connect it as a datasource to excel too.

answered Jun 28, 2012 at 4:55

nunespascal

17.7k2 gold badges45 silver badges46 bronze badges

2 Comments

Abadis Over a year ago

I Tested this code and it worked but there was a problem.I couldnt create new excel file.i had to use one ready excel file.you can test it your self.

The Original Android Over a year ago

@Abadis, look at link msdn.microsoft.com/en-us/library/… to create Workbooks and link msdn.microsoft.com/en-us/library/… to Open Workbooks. Basically you have to read up on Excel API and start understanding them. Sometimes MSDN doc provides code samples.

The Original Android · Accepted Answer · 2012-06-28 05:20:06Z

1

For now, I am providing links for you to read @ Excel Tasks and code samples @ Excel controls in ASP.net. If you're still confused, I may be able to find code samples from my projects or the Internet, which are not hard to find.

Look at link Workbook Open (create) method to create Workbooks, and link Workbook Open method to open Workbooks.

edited Jun 28, 2012 at 5:20

answered Jun 28, 2012 at 5:03

The Original Android

6,2353 gold badges28 silver badges32 bronze badges

Collectives™ on Stack Overflow

C# Excel 2010 programing

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related