public static void printDataSetToExcel(Excel.Workbook workbook, ListSerializableDataStruct lsds, int sheetNumber)
{
Excel.Worksheet newDataSetSheet = null;
Excel.Sheets excel_sheets = workbook.Worksheets;
newDataSetSheet = excel_sheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
newDataSetSheet.Name = "New Data Set" + sheetNumber;
for (int i = 4; i < lsds.dataTypesLabels.Count; i++)
{
newDataSetSheet.Cells[1, i - 3].Value2 = lsds.dataTypesLabels[i];
}
for (int i = 2; i < lsds.getCount() + 2; i++)
{
int j = 1;
SerializableDataStruct sds = lsds.getSDS(i - 2);
newDataSetSheet.Cells[i, j++].Value2 = sds.wind_speed;
newDataSetSheet.Cells[i, j++].Value2 = sds.cross_wind;
newDataSetSheet.Cells[i, j++].Value2 = sds.head_wind;
newDataSetSheet.Cells[i, j++].Value2 = sds.temp;
newDataSetSheet.Cells[i, j++].Value2 = sds.wind_chill;
newDataSetSheet.Cells[i, j++].Value2 = sds.rel_hum;
newDataSetSheet.Cells[i, j++].Value2 = sds.heat_index;
newDataSetSheet.Cells[i, j++].Value2 = sds.dew_point;
newDataSetSheet.Cells[i, j++].Value2 = sds.wet_bulb;
newDataSetSheet.Cells[i, j++].Value2 = sds.bar;
newDataSetSheet.Cells[i, j++].Value2 = sds.alt;
newDataSetSheet.Cells[i, j++].Value2 = sds.den_alt;
}
}
private void loadinList(bool alreadyLoadedOne)
{
OpenFileDialog openFileDialog = new System.Windows.Forms.OpenFileDialog();
FolderBrowserDialog folderBrowserDialog = new System.Windows.Forms.FolderBrowserDialog();
folderBrowserDialog.Description = "Select the directory that you want to use as the default.";
folderBrowserDialog.ShowNewFolderButton = false;
openFileDialog.DefaultExt = "osl";
openFileDialog.Filter = "osl files (*.osl)|*.osl";
folderBrowserDialog.RootFolder = Environment.SpecialFolder.Personal;
openFileDialog.InitialDirectory = folderBrowserDialog.SelectedPath;
openFileDialog.FileName = null;
DialogResult result = openFileDialog.ShowDialog();
if (result == DialogResult.OK)
{
string openFileName = openFileDialog.FileName;
try
{
Stream stream = File.Open(openFileName, FileMode.Open);
BinaryFormatter bformatter = new BinaryFormatter();
if (!alreadyLoadedOne)
{
list = (ListSerializableDataStruct)bformatter.Deserialize(stream);
}
else
tempLoadList = (ListSerializableDataStruct)bformatter.Deserialize(stream);
stream.Close();
}
catch (Exception exp)
{
MessageBox.Show("An error occurred while attempting to load the file. The error is:"
+ System.Environment.NewLine + exp.ToString() + System.Environment.NewLine);
}
Invalidate();
}
// Cancel button was pressed.
else if (result == DialogResult.Cancel)
{
return;
}
if (!alreadyLoadedOne)
PrintToExcelSheets.printDataSetToExcel(workbook, list, sheetNumber++);
}
public KestralDataManip(Excel.Worksheet sheet, Excel.Workbook workbook, KestrelDataAddInRibbon ribbon, bool dataOnSheet)
{
this.sheet = sheet;
this.workbook = workbook;
this.excelRibbon = ribbon;
whm = new WindowHandlerManager();
liveList = new ListSerializableDataStruct();
Excel.Worksheet AutoCollectDataSheet = null;
Excel.Sheets excel_sheets = workbook.Worksheets;
AutoCollectDataSheet = excel_sheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
AutoCollectDataSheet.Name = "Auto Collect";
InitializeComponent();
if (!dataOnSheet)
readData.Enabled = false;
}
public static ListSerializableDataStruct getDataSet(Excel.Range used_range, Excel.Workbook workbook)
{
ListSerializableDataStruct DataSet = new ListSerializableDataStruct();
int maxRow = used_range.Rows.Count;
int maxColumn = used_range.Columns.Count;
List <string> config = new List <string>();
for (int row = 1; row <= maxRow; row++)
{
if (row == 1)
{
for (int column = 1; column <= maxColumn; column++)
{
config.Add((string)used_range[row, column].Value2);
}
row++;
DataSet.setTypeList(config);
}
else
{
SerializableDataStruct newRecord = new SerializableDataStruct();
for (int column = 1; column <= maxColumn; column++)
{
object value = used_range[row, column].Value2;
if (config[column - 1] == "FORMATTED DATE-TIME")
{
value = used_range[row, column].Value;
DateTime dateTime = (DateTime)value;
}
else if (config[column - 1] == "DT")
{
double timeInSecs = (double)value;
newRecord.time_seconds = timeInSecs;
}
else if (config[column - 1] == "MG")
{
string mg = (string)value;
newRecord.mag_dir = mg;
}
else if (config[column - 1] == "TR")
{
string mg = (string)value;
newRecord.true_dir = mg;
}
else if (config[column - 1] == "WS")
{
double ws = (double)value;
newRecord.wind_speed = ws;
}
else if (config[column - 1] == "CW")
{
double cw = (double)value;
newRecord.cross_wind = cw;
}
else if (config[column - 1] == "HW")
{
double hw = (double)value;
newRecord.head_wind = hw;
}
else if (config[column - 1] == "TP")
{
double tp = (double)value;
newRecord.temp = tp;
}
else if (config[column - 1] == "WC")
{
double wc = (double)value;
newRecord.wind_chill = wc;
}
else if (config[column - 1] == "RH")
{
double rh = (double)value;
newRecord.rel_hum = rh;
}
else if (config[column - 1] == "HI")
{
double hi = (double)value;
newRecord.heat_index = hi;
}
else if (config[column - 1] == "DP")
{
double dp = (double)value;
newRecord.dew_point = dp;
}
else if (config[column - 1] == "WB")
{
double wb = (double)value;
newRecord.wet_bulb = wb;
}
else if (config[column - 1] == "BP")
{
double bp = (double)value;
newRecord.bar = bp;
}
else if (config[column - 1] == "AL")
{
double al = (double)value;
newRecord.alt = al;
}
else if (config[column - 1] == "DA")
{
double da = (double)value;
newRecord.den_alt = da;
}
}
DataSet.add(newRecord);
}
}
return(DataSet);
}
private void readData_Click(object sender, EventArgs e)
{
list = ProcessExcelData.getDataSet(sheet.UsedRange, workbook);
}
