private void btnConvertToXml_Click(object sender, EventArgs e)
{
if (File.Exists(txtFile.Text) == false)
{
return;
}
XmlDocument xmlRawFile = null;
try
{
Cursor = Cursors.WaitCursor;
if (cboExcelWorksheet.SelectedIndex > -1)
{
RawFileConverter.ExcelWorksheetName = cboExcelWorksheet.SelectedItem.ToString();
}
RawFileConverter.AccessDatabaseQuery = txtAccessQuery.Text.Trim();
RawFileConverter.PerformValidationCleanup = chkCleanupXml.Checked;
xmlRawFile = RawFileConverter.ConvertFileToRawXml(txtFile.Text);
}
catch (Exception ex)
{
MessageBox.Show("Error converting file! " + ex.Message);
return;
}
finally
{
Cursor = Cursors.Default;
}
m_sXmlFilePath = FileUtilities.GetUniqueTempFileName(".xml"); // add the xml extension so the browser can read it
xmlRawFile.Save(m_sXmlFilePath);
ApplyOverrideElements(m_sXmlFilePath, txtRootElement.Text, txtRowElement.Text);
xmlXmlOutputGridView.DataFilePath = m_sXmlFilePath;
tabOutput.SelectTab(tabXmlOutput);
SetBehavior();
}
private void btnGetWorksheets_Click(object sender, EventArgs e)
{
cboExcelWorksheet.Items.Clear();
cboExcelWorksheet.Items.AddRange(RawFileConverter.GetExcelWorksheets(txtFile.Text.Trim()));
cboExcelWorksheet.DroppedDown = true;
}