/// <summary>
/// 删除zip文件及解压后的文件夹
/// </summary>
public void DeleteFile()
{
DeleteFolder(m_OutZipFilePath);
if (File.Exists(m_ZipFilePath))
{
File.Delete(m_ZipFilePath);//删除zip文件
}
}
/// <summary>
/// 根据解压后的XML文件提取所有的sheet名
/// </summary>
/// <returns></returns>
private List<string> GetSheetNameByXml(string outZipFilePath)
{
List<string> ExcelSheetNameList = new List<string>();
XmlDocument doc = new XmlDocument();
doc.Load(outZipFilePath + @"/xl/workbook.xml");
XmlNode xmlNode = doc.ChildNodes[1];
XmlNodeList xmlNodeList = null;
foreach (XmlNode node in xmlNode)
{
if (node.Name == "sheets")
{
xmlNodeList = node.ChildNodes;
break;
}
}
foreach (XmlNode node in xmlNodeList)
{
ExcelSheetNameList.Add(node.Attributes.Item(0).Value.ToString());
}
doc.RemoveAll();
return ExcelSheetNameList;
}