private void ExportListResultsToExcelSPSS(ExcelWorkBookAdaptor wbk, List <LocalityResult> results, int policyIndex, ref int row)
{
int localityIndex = 1;
var policyIndexList = new List <int>();
Enumerable.Range(0, results[0].Data.Count).ToList().ForEach(x => policyIndexList.Add(policyIndex));
foreach (var result in results)
{
var startRow = row;
var pipe = new ListToExcelTableAdaptor <double>(wbk[0], result.Data);
pipe.Write(new ExcelCellCoordinate(startRow, 1), 1);
startRow = row;
var policyPipe = new ListToExcelTableAdaptor <int>(wbk[0], policyIndexList);
policyPipe.Write(new ExcelCellCoordinate(startRow, 2), 1);
startRow = row;
var localityIndexList = new List <int>();
Enumerable.Range(0, results[0].Data.Count).ToList().ForEach(x => localityIndexList.Add(localityIndex));
var localityPipe = new ListToExcelTableAdaptor <int>(wbk[0], localityIndexList);
localityPipe.Write(new ExcelCellCoordinate(startRow, 3), 1);
row += result.Data.Count;
localityIndex++;
}
}
public static void Main(string[] args)
{
Console.WriteLine("Hello World!");
// TODO: Implement Functionality Here
//adaptor.OpenExisting(@"C:\Test Excel\Book1.xlsx");
var data = new List <double>();
data.Add(10);
data.Add(10);
data.Add(10);
data.Add(10);
data.Add(10);
var data2 = new List <string>();
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
var adaptor = new ExcelWorkBookAdaptor();
adaptor.NewBook();
var listAdapter = new ListToExcelTableAdaptor <string>(adaptor[0], data2);
listAdapter.Write(new ExcelCellCoordinate(10, 10), 2);
var format = new ExcelRangeTableStyle(adaptor[0], new ExcelCellCoordinate(10, 10), new ExcelCellCoordinate(15, 15))
{
FirstRowContainHeaders = true
};
format.Execute();
adaptor.Show();
Console.Write("Press any key to continue . . . ");
Console.ReadKey(true);
adaptor.SaveAndClose(@"C:\Test Excel\Book2.xlsx");
}
private void ExportListResultsToExcel(ExcelWorkBookAdaptor wbk, int sheetIndex, List <LocalityResult> results)
{
int column = 1;
foreach (var result in results)
{
var pipe = new ListToExcelTableAdaptor <double>(wbk[sheetIndex], result.Data);
pipe.Write(new ExcelCellCoordinate(1, column++), 1);
}
}
public static void Main(string[] args)
{
Console.WriteLine("Hello World!");
// TODO: Implement Functionality Here
//adaptor.OpenExisting(@"C:\Test Excel\Book1.xlsx");
var data = new List<double>();
data.Add(10);
data.Add(10);
data.Add(10);
data.Add(10);
data.Add(10);
var data2 = new List<string>();
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
data2.Add("hello");
var adaptor = new ExcelWorkBookAdaptor();
adaptor.NewBook();
var listAdapter = new ListToExcelTableAdaptor<string>(adaptor[0], data2);
listAdapter.Write(new ExcelCellCoordinate(10, 10), 2);
var format = new ExcelRangeTableStyle(adaptor[0], new ExcelCellCoordinate(10, 10), new ExcelCellCoordinate(15, 15)) { FirstRowContainHeaders = true };
format.Execute();
adaptor.Show();
Console.Write("Press any key to continue . . . ");
Console.ReadKey(true);
adaptor.SaveAndClose(@"C:\Test Excel\Book2.xlsx");
}
