public void CreateXlsDoc()
{
ExcelHandler excelHndlr = new ExcelHandler();
string codeBase = AppContext.BaseDirectory;
int fileName = 0;
string outputFile;
do
{
outputFile = Path.Combine(codeBase, $"{fileName++}.xlsx");
} while (File.Exists(outputFile));
const int ASCII_ALPHAS_OFFSET = 65;
string[,] data = new string[10, 16];
for (int i = 0; i < data.GetLength(0); i++)
{
for (int j = 0; j < data.GetLength(1); j++)
{
data[i, j] = Convert.ToChar(ASCII_ALPHAS_OFFSET + j).ToString();
}
}
excelHndlr.CreateXlsDoc(outputFile, $"A{2}", $"P{10}", data);
}
private void btnGenerateReport_Click(object sender, RoutedEventArgs e)
{
try
{
var data = htmlHandler.ReadReportData(txtBoxToHtmlReport.Text);
using (xlsHanlder)
xlsHanlder.CreateXlsDoc(txtBoxToHtmlReport.Text, "A2", $"P{data.GetLength(0)}", data);
}
catch (Exception ex)
{
RaiseErorrMessageBox("Report generation is failed. Check if you have specified the folder with html data.", "Failure");
}
}
