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!");
}
