/
ExcelReader.cs
89 lines (78 loc) · 2.71 KB
/
ExcelReader.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
// ***********************************************************************
// Assembly : ExcelManager
// Author : Dheeraj
// ***********************************************************************
// <copyright file="Cell.cs" company="">
// Copyright (c) . All rights reserved.
// </copyright>
// <summary></summary>
// ***********************************************************************
using System;
using System.Collections.Generic;
using System.IO;
using System.IO.Compression;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Xml.Linq;
using System.Xml.Serialization;
using Windows.ApplicationModel;
using Windows.Data.Xml.Dom;
using Windows.Storage;
using ExcelManager.Entity;
namespace ExcelManager
{
/// <summary>
/// Class meant for Reading Excel File
/// </summary>
public class ExcelReader
{
public ExcelReader()
{
//throw new NotImplementedException();
}
public void ReadExcelData(Stream excelfile)
{
//excelfile = Assembly.Load(new AssemblyName("ExcelManager")).GetManifestResourceStream(@"ExcelManager.Resources.ExcelTemplateFile.xlsx");
System.IO.Compression.ZipArchive zipArchiveExcelTemplate = new System.IO.Compression.ZipArchive(excelfile);
foreach (var file in zipArchiveExcelTemplate.Entries)
{
if (file.FullName == "xl/sharedStrings.xml")
{
var s = file.Open();
var xdoc = XDocument.Load(s);
var xelement = XElement.Parse(xdoc.ToString());
var sst = Deserialize<sst>(xelement.ToString());
}
else if (file.FullName == "xl/worksheets/sheet1.xml")
{
var s = file.Open();
var xdoc = XDocument.Load(s);
var xelement = XElement.Parse(xdoc.ToString());
var worksheet = Deserialize<worksheet>(xelement.ToString());
}
else if (file.FullName == "xl/styles.xml")
{
//parsing cant be done as of now
}
else
{
}
}
}
public T Deserialize<T>(string xmlString) where T : class
{
try
{
XmlSerializer xmlSerializer = new XmlSerializer(typeof(T));
TextReader xmlText = new StringReader(xmlString);
T xmlObject = (T)xmlSerializer.Deserialize(xmlText);
return xmlObject;
}
catch (Exception ex)
{
return null;
}
}
}
}