Create Spreadsheet using xml file

Question

1.00/5 (1 vote)

See more:

SQL

I have to create a spreadsheet using XMLfile with Open XML SDK.

For Example, I have data in Product.xml file. By using this file i want to create a spreadsheet.

Posted 23-Apr-14 3:04am

Sarath02

Add a Solution

Comments

joshrduncan2012 23-Apr-14 9:17am

Ok, you may proceed. What is your question?

Sarath02 23-Apr-14 9:24am

Here i want to create a spreadsheet using xml file.

joshrduncan2012 23-Apr-14 9:38am

That doesn't answer my question. That is a vague statement. What have you tried so far? Where are you stuck? What specific questions do you have relating to creating a spreadsheet from an XML file.

Sarath02 23-Apr-14 9:56am

i have xml files in my project. by using this xml file i want to create spreadsheet. i want code. Here it is not possible for posting the total code. so, can you please write some code for me related to that topic.

joshrduncan2012 23-Apr-14 9:59am

I'm not providing code without seeing some effort on your part first. This forum is for asking questions relating to code that you have already written, not for us to provide ready-made code.

Sarath02 23-Apr-14 10:10am

okay josh...Here is my code...

protected void Page_Load(object sender, EventArgs e)
{
String fileName = @"C:\Users\Public\Documents\ExcelData.xlsx";
// Comment one of the following lines to test the method separately.
ReadExcelFileDOM(fileName); // DOM
ReadExcelFileSAX(fileName); // SAX

}

static void ReadExcelFileDOM(string fileName)
{
using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(fileName, false))
{
WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
WorksheetPart worksheetPart = workbookPart.WorksheetParts.First();
SheetData sheetData = worksheetPart.Worksheet.Elements<sheetdata>().First();
string text;
foreach (Row r in sheetData.Elements<row>())
{
foreach (Cell c in r.Elements<cell>())
{
text = c.CellValue.Text;
Console.Write(text + " ");
}
}
Console.WriteLine();
//Console.ReadKey();
}
}

// The SAX approach.
static void ReadExcelFileSAX(string fileName)
{
using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(fileName, false))
{
WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
WorksheetPart worksheetPart = workbookPart.WorksheetParts.First();

OpenXmlReader reader = OpenXmlReader.Create(worksheetPart);
string text;
while (reader.Read())
{
if (reader.ElementType == typeof(CellValue))
{
text = reader.GetText();
Console.Write(text + " ");
}
}
Console.WriteLine();
//Console.ReadKey();
}
}

joshrduncan2012 23-Apr-14 10:13am

Are you getting any errors at all? If so, what line is it pointing to? If you aren't getting any errors, what kind of output are you getting?

Sarath02 23-Apr-14 10:18am

After running the project it will show empty page....and it will not show any error..see below link once

http://www.evernote.com/shard/s419/sh/e70ebb6c-c33c-4556-b182-163376cae659/6f7b7ac2628864531a3fd467b8ce604f

Sarath02 23-Apr-14 10:20am

For that reason i am asking the code josh. why i am not getting the output i will not understand. so, can you please help e now....For creating spreadsheet using xml file with Open XML SDK.

joshrduncan2012 23-Apr-14 12:45pm

Did you use any SDK available somewhere? If so, where did you find it?

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)