public static bool ConvertExcelToXml() { try { string excelPath = @"C:\Users\MEHMTEKE\Desktop\Excel_Xml"; DataTable dataTable = ExcelXmlXsdOperation.GetExcelDataInDataTableFormat(excelPath, "Book$"); string xmlString = ConvertDataTableDataToString(dataTable); string date = DateTime.Now.ToString("yyyyMMdd-HHmmss", System.Globalization.CultureInfo.InvariantCulture); string xmlFilePath = excelPath + "XML_" + date + ".xml"; if (!Directory.Exists(excelPath)) { Directory.CreateDirectory(excelPath); } using (StreamWriter writer = new StreamWriter(xmlFilePath, true, Encoding.UTF8, 65536)) { writer.Write(xmlString); } } catch (Exception ex) { Console.WriteLine("Hata " + ex.Message.ToString()); throw; } return(true); }
static void Main(string[] args) { //ExcelXmlXsdOperation.ConvertExcelToXml(); ExcelXmlXsdOperation.ValidateXmlWithXsd(); Console.ReadKey(); Console.WriteLine("Hello World!"); }