public void ColumnNames()
{
string filename = TestData.DataPath + "\\ImportWithUpdate.xls";
SpreadsheetGearExcel db = new SpreadsheetGearExcel(filename);
string[] cols = db.ColumnNames("Duplicates");
foreach (var s in cols)
{
Console.WriteLine(s);
}
Assert.AreEqual(34, cols.Length);
}
private void RefreshColumnNames()
{
this.comboBoxDateColumn.Items.Clear();
this.comboBoxFilter.Items.Clear();
this.checkedListBoxSites.Items.Clear();
this.comboBoxValueColumn.Items.Clear();
string[] columnNames = { };
labelError.Text = "";
try
{
if (this.radioButtonHeaderRow.Checked)
{
columnNames = db.ColumnNames(SheetName);
}
else
{
columnNames = db.ColumnReferenceNames(SheetName);
}
}
catch (DuplicateNameException e)
{
columnNames = new string[] {};
labelError.Text = "Error: " + e.Message;
}
this.comboBoxDateColumn.Items.AddRange(columnNames);
this.comboBoxFilter.Items.AddRange(columnNames);
this.comboBoxValueColumn.Items.AddRange(columnNames);
if (columnNames.Length > 0)
{
comboBoxDateColumn.SelectedIndex = 0;
//comboBoxValueColumn.SelectedIndex = 0;
buttonOK.Enabled = true;
}
else
{
buttonOK.Enabled = false;
}
}