public void Write2DAToExcel(string path)
{
var workbook = new XLWorkbook();
var worksheet = workbook.Worksheets.Add(export.ObjectName.Truncate(30));
//write labels
for (int rowindex = 0; rowindex < RowNames.Count(); rowindex++)
{
worksheet.Cell(rowindex + 2, 1).Value = RowNames[rowindex];
}
for (int colindex = 0; colindex < ColumnNames.Count(); colindex++)
{
worksheet.Cell(1, colindex + 2).Value = ColumnNames[colindex];
}
//write data
for (int rowindex = 0; rowindex < RowNames.Count(); rowindex++)
{
for (int colindex = 0; colindex < ColumnNames.Count(); colindex++)
{
if (Cells[rowindex, colindex] != null)
{
worksheet.Cell(rowindex + 2, colindex + 2).Value = Cells[rowindex, colindex].GetDisplayableValue();
}
}
}
worksheet.SheetView.FreezeRows(1);
worksheet.SheetView.FreezeColumns(1);
worksheet.Columns().AdjustToContents();
workbook.SaveAs(path);
}
public void Write2DAToExport()
{
using (var stream = new MemoryStream())
{
//Cell count
if (IsIndexed)
{
//Indexed ones seem to have 0 at start
stream.WriteBytes(BitConverter.GetBytes(0));
}
stream.WriteBytes(BitConverter.GetBytes(CellCount));
//Write cell data
for (int rowindex = 0; rowindex < RowNames.Count(); rowindex++)
{
for (int colindex = 0; colindex < ColumnNames.Count(); colindex++)
{
Bio2DACell cell = Cells[rowindex, colindex];
if (cell != null)
{
if (IsIndexed)
{
//write index
int index = (rowindex * ColumnNames.Count()) + colindex; //+1 because they are not zero based indexes since they are numerals
stream.WriteBytes(BitConverter.GetBytes(index));
}
stream.WriteByte(cell.Type);
stream.WriteBytes(cell.Data);
}
else
{
if (IsIndexed)
{
//this is a blank cell. It is not present in the table.
continue;
}
else
{
Console.WriteLine("THIS SHOULDN'T OCCUR!");
}
}
}
}
//Write Columns
if (!IsIndexed)
{
stream.WriteBytes(BitConverter.GetBytes(0)); //seems to be a 0 before column definitions
}
//Console.WriteLine("Columns defs start at " + stream.Position.ToString("X6"));
stream.WriteBytes(BitConverter.GetBytes(ColumnNames.Count()));
for (int colindex = 0; colindex < ColumnNames.Count(); colindex++)
{
//Console.WriteLine("Writing column definition " + columnNames[colindex]);
int nameIndexForCol = export.FileRef.findName(ColumnNames[colindex]);
stream.WriteBytes(BitConverter.GetBytes(nameIndexForCol));
stream.WriteBytes(BitConverter.GetBytes(0)); //second half of name reference in 2da is always zero since they're always indexed at 0
stream.WriteBytes(BitConverter.GetBytes(colindex));
}
int propsEnd = export.propsEnd();
byte[] binarydata = stream.ToArray();
byte[] propertydata = export.Data.Take(propsEnd).ToArray();
var newExportData = new byte[propertydata.Length + binarydata.Length];
propertydata.CopyTo(newExportData, 0);
binarydata.CopyTo(newExportData, propertydata.Length);
//Console.WriteLine("Old data size: " + export.Data.Length);
//Console.WriteLine("NEw data size: " + newExportData.Length);
if (export.Data.Length != newExportData.Length)
{
Console.WriteLine("FILES ARE WRONG SIZE");
Debugger.Break();
}
export.Data = newExportData;
}
}
