private void newNToolStripMenuItem_Click(object sender, EventArgs e)
{
//test create xls file
string file = "C:\\newdoc.xls";
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("First Sheet");
worksheet.Cells[0, 1] = new Cell((short)1);
worksheet.Cells[2, 0] = new Cell(2.8);
worksheet.Cells[3, 3] = new Cell((decimal)3.45);
worksheet.Cells[2, 2] = new Cell("Text string");
worksheet.Cells[2, 4] = new Cell("Second string");
worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00");
worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD");
worksheet.Cells.ColumnWidth[0, 1] = 3000;
//Picture pic = new Picture();
//pic.Image = Excel.Image.FromFile("C:\\DelBreakpoint.png");
//pic.TopLeftCorner = new CellAnchor(5, 1, 0, 0);
//pic.BottomRightCorner = new CellAnchor(12, 5, 592, 243);
//worksheet.AddPicture(pic);
workbook.Worksheets.Add(worksheet);
workbook.Save(file);
//open created file
doc = CompoundDocument.Open(file);
IsOpened = true;
PopulateTreeview(file);
}
public void WriteLongTextTest()
{
int longTextLength = 50000;
StringBuilder builder = new StringBuilder(longTextLength);
for (int i = 0; i < longTextLength; i++)
builder.Append('A');
string longText = builder.ToString();
string tempFilePath = Path.GetTempFileName();
{
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Test");
worksheet.Cells[0, 0] = new Cell(longText);
workbook.Worksheets.Add(worksheet);
workbook.Save(tempFilePath);
}
{
Workbook workbook = Workbook.Load(tempFilePath);
Assert.AreEqual(longText, workbook.Worksheets[0].Cells[0, 0].Value);
}
}
public static void ExportToExcel(DataSet dataSet, string outputPath)
{
Workbook workbook = new Workbook();
foreach (DataTable dt in dataSet.Tables)
{
Worksheet worksheet = new Worksheet(dt.TableName);
for (int i = 0; i < dt.Columns.Count; i++)
{
// Add column header
worksheet.Cells[0, i] = new Cell(dt.Columns[i].ColumnName);
// Populate row data
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j][i] == DBNull.Value)
worksheet.Cells[j + 1, i] = new Cell(string.Empty);
else
if (dt.Columns[i].DataType == typeof(DateTime))
{
worksheet.Cells[j + 1, i] = new Cell(dt.Rows[j][i], new CellFormat(CellFormatType.Date, "DD.MM.YYYY"));
}
else
worksheet.Cells[j + 1, i] = new Cell(dt.Rows[j][i]);
}
}
workbook.Worksheets.Add(worksheet);
}
workbook.Save(outputPath);
}
public Worksheet EnteteSRFLigne2(Worksheet worksheet,string NomSoc,string Date1,string Date2,string CodeSoc,bool PeNormal,bool Bonus,string DatePe)
{
worksheet.Cells[1, 0] = new Cell("D0");
worksheet.Cells[1, 1] = new Cell("UTF8");
worksheet.Cells[1, 2] = new Cell((DateTime.Now.ToString().Substring(0,10)));
string HeureMin = ExtraireHeure(DateTime.Now.Hour.ToString(),DateTime.Now.Minute.ToString(),DateTime.Now.Second.ToString());
worksheet.Cells[1, 3] = new Cell(HeureMin);
worksheet.Cells[1, 4] = new Cell("SRF");
worksheet.Cells[1, 5] = new Cell("M2.0.2.0");
worksheet.Cells[1, 6] = new Cell("F1.0.0");
worksheet.Cells[1, 7] = new Cell("ABC");
worksheet.Cells[1, 8] = new Cell("TN");
worksheet.Cells[1, 9] = new Cell(CodeSoc);
worksheet.Cells[1, 10] = new Cell(NomSoc);
worksheet.Cells[1, 11] = new Cell("TN");
worksheet.Cells[1, 12] = new Cell("TND");
worksheet.Cells[1, 13] = new Cell(DatePe);
worksheet.Cells[1, 14] = new Cell(Date1);
worksheet.Cells[1, 15] = new Cell(Date2);
worksheet.Cells[1, 16] = new Cell(1);
int leMois = int.Parse(Date1.Substring(3, 2));
string MoisC = service.NomDuMoisEnglish(leMois);
string Year = Date1.Substring(6,4);
worksheet.Cells[1, 17] = new Cell("payroll "+MoisC+" "+Year);
string TypePay = TypedePayroll(PeNormal, Bonus);
worksheet.Cells[1, 18] = new Cell(TypePay);
worksheet.Cells[1, 19] = new Cell(0);
return worksheet;
}
//private DocumentService documentService =new DocumentService();
public static string FileGen(string fileName,List<List<string>> sheet )
{
if (!Directory.Exists(Constants.ImportTempFolder))
Directory.CreateDirectory(Constants.ImportTempFolder);
string file = Constants.ImportTempFolder+fileName;
if (File.Exists(file))
{
try
{
File.Delete(file);
}
catch (Exception)
{
return null;
}
}
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("First Sheet");
for (int row=0; row<sheet.Count;row++)
{
for (var col = 0; col < sheet[row].Count;col++ )
{
worksheet.Cells[row, col] = new Cell(sheet[row][col]);
}
}
workbook.Worksheets.Add(worksheet);
workbook.Save(file);
return file;
}
public Worksheet EnteteOPR8Ligne1(Worksheet worksheet,string NomSoc)
{
worksheet.Cells[0, 0] = new Cell("Client");
worksheet.Cells[0, 1] = new Cell(NomSoc);
return worksheet;
}
public Worksheet EnteteOPR8Ligne2(Worksheet worksheet)
{
worksheet.Cells[1, 0] = new Cell("OPR 08");
worksheet.Cells[1, 1] = new Cell("Comparatif Payement par Virement");
return worksheet;
}
public static void excel_batch_template(WSProject p)
{
string file = @"C:\Users\WindSim\Desktop\Francesco\WindSim_Projects\MoninObukhov\batch.xls";
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Batch Data");
// this cycle add some null cells because when on Windows 7 Office need at least 6000byte files.
//----------------------------------------------
for (var k = 0; k < 200; k++)
worksheet.Cells[k, 0] = new Cell(null);
// ---------------------------------------------
XmlReader reader = XmlReader.Create(p.file.FullName);
int i = 0;
while (reader.Read())
{
if (reader.NodeType == XmlNodeType.EndElement)
{
worksheet.Cells[i, 0] = new Cell(reader.Name);
if (reader.Read())
{
worksheet.Cells[i, 1] = new Cell(reader.Value.Trim());
}
i++;
}
}
workbook.Worksheets.Add(worksheet);
workbook.Save(file);
}
public Worksheet EnteteOPR17Ligne2(Worksheet worksheet)
{
worksheet.Cells[1, 0] = new Cell("OPR 17");
worksheet.Cells[1, 1] = new Cell("Payroll summary");
return worksheet;
}
public Worksheet EnteteOPR11Ligne2(Worksheet worksheet)
{
worksheet.Cells[1, 0] = new Cell("OPR 11");
worksheet.Cells[1, 1] = new Cell("OT Report");
return worksheet;
}
public void EcritureC(int idSoc, Worksheet worksheet, int MoisPe, int AnneePe)
{
// if (idSoc == 2)
// {
worksheet = entete.EnteteSVRLigne14(worksheet, idSoc, MoisPe, AnneePe);
// }
}
public static void WriteDataTable(Worksheet ws, int row, int col, DataTable table, bool writeHeaders)
{
int curCol = col;
if (writeHeaders)
{
foreach (DataColumn column in table.Columns)
{
WriteCell(ws, row, curCol, column.Caption, TableHeader);
curCol++;
}
row++;
}
foreach (DataRow curRow in table.Rows)
{
curCol = col;
foreach (DataColumn column in table.Columns)
{
WriteCell(ws, row, curCol, curRow[column], TableCell);
curCol++;
}
row++;
}
}
public Worksheet EnteteOPR15Ligne2(Worksheet worksheet)
{
worksheet.Cells[1, 0] = new Cell("OPR 15");
worksheet.Cells[1, 1] = new Cell("FINANCIAL REPORT");
return worksheet;
}
public static void WriteCell(Worksheet ws, int row, int col, object value, CellStyle style)
{
object temp = null;
if (value is MySqlDateTime)
{
temp = ((MySqlDateTime)value).GetDateTime();
}
else
{
temp = value;
}
if (temp != null && temp != DBNull.Value)
{
if (temp is DateTime)
{
ws.Cells[row, col] = new Cell(temp);
ws.Cells[row, col].Format = DateCellFormat;
}
else
{
ws.Cells[row, col] = new Cell(temp);
}
}
else
{
ws.Cells[row, col] = new Cell(String.Empty);
}
if (style != null)
{
ws.Cells[row, col].Style = style;
}
}
public static void SetColumnsWidth(Worksheet ws, params ushort[] widths)
{
for (ushort i = 0; i < widths.Length; i++)
{
ws.Cells.ColumnWidth[i] = widths[i];
}
}
public void SimpleMultipleSheetTest()
{
int worksheetToCreate = 10;
string tempFilePath = Path.GetTempFileName();
{
Workbook workbook = new Workbook();
for (int i = 0; i < worksheetToCreate; i++)
{
Worksheet worksheetWrite2 = new Worksheet(String.Format("Sheet {0}", i));
workbook.Worksheets.Add(worksheetWrite2);
}
workbook.Save(tempFilePath);
}
{
Workbook workbook = Workbook.Load(tempFilePath);
Assert.AreEqual(worksheetToCreate, workbook.Worksheets.Count);
for (int i = 0; i < worksheetToCreate; i++)
{
Assert.AreEqual(String.Format("Sheet {0}", i), workbook.Worksheets[i].Name);
}
}
}
private void writeHeader(string filename)
{
Workbook workbook;
if (File.Exists(filename))
workbook = Workbook.Load(filename);
else
workbook = new Workbook();
Worksheet akWorksheet = null;
foreach (Worksheet worksheet in workbook.Worksheets)
{
if (worksheet.Name == TableName)
akWorksheet = worksheet;
}
if (akWorksheet == null)
{
akWorksheet = new Worksheet(TableName);
workbook.Worksheets.Add(akWorksheet);
}
int n = 0;
foreach (DatasetConfigRow myFeld in datasetConfig.DatasetConfigRows)
{
akWorksheet.Cells[0, n] = new Cell(myFeld.DatabaseField);
n++;
}
workbook.Save(filename);
}
public ExcelAngleData()
{
worksheet = new Worksheet("angles");
PhoneAngletimer = new DispatcherTimer();
//samplerate for saving phone angles can changed here.
PhoneAngletimer.Interval = TimeSpan.FromMilliseconds(200);
PhoneAngletimer.Tick += PhoneAngletimer_Tick;
}
public CursorExcel2003(byte[] data)
{
var wb = Workbook.Load(new MemoryStream(data));
if (wb == null || wb.Worksheets.Count <= 0)
throw new ReportFormatException("Data was not recognized as Excel2003");
_worksheet = wb.Worksheets[0];
}
public Worksheet EnteteSVRLigne8(Worksheet worksheet,string Date1,string Date2)
{
string DT1 = form.LA_DATE_ADP(Date1);
string DT2 = form.LA_DATE_ADP(Date2);
worksheet.Cells[7, 0] = new Cell("Pay Cycle");
worksheet.Cells[7, 1] = new Cell(DT1+"-"+DT2);
return worksheet;
}
public static void AddParticipantToWorksheet(Worksheet ws, int row, IParticipant p)
{
string participantData = GetParticipantData(p, null);
string[] participantValues = participantData.Split(';');
for (int i = 0; i < participantValues.Length; i++)
{
ws.Cells[row, i] = new Cell(participantValues[i]);
}
}
public static void Create(string filename)
{
Filename = filename;
workbook = new Workbook();
worksheet = new Worksheet("Output");
for (int i = 0; i < 100; i++)
worksheet.Cells[i, 0] = new Cell("");
}
public static Worksheet Decode(Workbook book, Stream stream, SharedResource sharedResource)
{
Worksheet sheet = new Worksheet();
sheet.Book = book;
List<Record> records = ReadRecords(stream, out sheet.Drawing);
sheet.Cells = PopulateCells(records, sharedResource);
sheet.Book.Records.AddRange(records);
return sheet;
}
public static void ExportXLSX(List<IParticipant> participants, List<string> formFields)
{
string eventName = (participants.Count > 0) ? ((participants[0] != null && participants[0].EventPage != null && participants[0].EventPage != PageReference.EmptyReference) ? EPiServer.DataFactory.Instance.Get<PageData>(participants[0].EventPage).URLSegment : "NA" ) : "NA";
string fileName = EPiServer.Framework.Localization.LocalizationService.Current.GetString("/attend/edit/participants") + " - " + eventName;
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls");
HttpContext.Current.Response.Charset = Encoding.UTF8.WebName;
HttpContext.Current.Response.ContentEncoding = Encoding.UTF8;
HttpContext.Current.Response.BinaryWrite(Encoding.UTF8.GetPreamble());
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.BufferOutput = true;
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Participants");
if(formFields != null)
for(int i = 0; i < formFields.Count; i++)
worksheet.Cells[0, i]= new Cell(formFields[i]);
else if(participants.Count > 0)
{
string[] headers = AttendRegistrationEngine.GetFormData(participants[0]).AllKeys;
worksheet.Cells[0, 0] = new Cell("Status");
worksheet.Cells[0, 1] = new Cell("E-mail");
worksheet.Cells[0, 2] = new Cell("Code");
for (int i = 0; i < headers.Length; i++)
{
worksheet.Cells[0, i+3] = new Cell(headers[i]);
}
}
for (int i = 0; i < participants.Count; i++)
{
AddParticipantToWorksheet(worksheet, i+1, participants[i]);
}
// Some Excel versions requires more than 100 rows - adding empty ones
for (int i = participants.Count; i < 150; i++)
worksheet.Cells[i, 0] = new Cell(string.Empty);
workbook.Worksheets.Add(worksheet);
MemoryStream ms = new MemoryStream();
workbook.SaveToStream(ms);
ms.WriteTo(HttpContext.Current.Response.OutputStream);
HttpContext.Current.Response.End();
}
public void RelatedTest()
{
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Test");
workbook.Worksheets.Add(worksheet);
DateTime date = new DateTime(2009, 2, 13, 11, 30, 45);
worksheet.Cells[0, 0] = new Cell(date);
Assert.IsNotNull(worksheet.Cells[0, 0].Format);
}
public void Test()
{
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Test");
workbook.Worksheets.Add(worksheet);
DateTime date = new DateTime(2009, 2, 13, 11, 30, 45);
worksheet.Cells[0, 0] = new Cell(date);
worksheet.Cells[0, 0].DateTimeValue = date;
Assert.AreEqual(date, worksheet.Cells[0, 0].DateTimeValue);
}
private static void AddWhitespace(int index, Worksheet worksheet)
{
var row = index + 50;
for (int i = 0; i < 150; i++)
{
var col = 1;
for (int j = 0; j < 10; j++)
{
worksheet.Cells[row, col] = new Cell(" ");
col++;
}
row++;
}
}
private static void AddStudentDataToSheet(Worksheet sheet, int row, XcelStudent student)
{
sheet.Cells[row, 0] = new Cell(student.ID);
sheet.Cells[row, 1] = new Cell(student.FirstName);
sheet.Cells[row, 2] = new Cell(student.LastName);
sheet.Cells[row, 3] = new Cell(student.Email);
sheet.Cells[row, 4] = new Cell(student.Gender.ToString());
sheet.Cells[row, 5] = new Cell(student.StudentType.ToString());
sheet.Cells[row, 6] = new Cell(student.ExamResult);
sheet.Cells[row, 7] = new Cell(student.HomeworksSent);
sheet.Cells[row, 8] = new Cell(student.HomeworksEvaluated);
sheet.Cells[row, 9] = new Cell(student.Teamwork);
sheet.Cells[row, 10] = new Cell(student.Attendance);
sheet.Cells[row, 11] = new Cell(student.Bonus);
sheet.Cells[row, 12] = new Cell(student.CalculateResult());
}
static void Main()
{
helper.ConsoleMio.Setup();
helper.ConsoleMio.PrintHeading("LINQ to Excel ");
var studentsExtractor = new TextDocumentParser();
IList<XcelStudent> students =
studentsExtractor.Genereate(1000).Cast<XcelStudent>().ToList();
var sheet = new Worksheet("Online Students");
string[] sheetHeader = studentsExtractor.HeaderLine;
for (int i = 0; i < sheetHeader.Length; i++)
{
sheet.Cells[0, i] = new Cell(sheetHeader[i]);
}
// Add the result filed in the end
sheet.Cells[0, sheetHeader.Length] = new Cell("Result");
helper.ConsoleMio.PrintColorText("Proccessing information...\n\n", ConsoleColor.DarkCyan);
var onlineStudents = students
.Where(student => student.StudentType == StudentType.Online)
.OrderByDescending(student => student.CalculateResult())
.ToArray();
for (int i = 0; i < onlineStudents.Length; i++)
{
XcelStudent student = onlineStudents[i];
AddStudentDataToSheet(sheet, i + 1, student);
}
var workbook = new Workbook();
workbook.Worksheets.Add(sheet);
helper.ConsoleMio.PrintColorText(
"Query Completed\n", ConsoleColor.Green);
string saveLocation = helper.SelectSaveLocation("Xcel Files|*.xls");
workbook.Save(saveLocation);
helper.ConsoleMio.PrintColorText("Done", ConsoleColor.Green);
helper.ConsoleMio.Restart(Main);
}
/// <summary>
/// test excel library
/// </summary>
public static void ExcelLibraryTest()
{
//create new xls file
string file = "C:\\temp\\newdoc.xls";
ExcelLibrary.SpreadSheet.Workbook workbook = new ExcelLibrary.SpreadSheet.Workbook();
ExcelLibrary.SpreadSheet.Worksheet worksheet = new ExcelLibrary.SpreadSheet.Worksheet("First Sheet");
worksheet.Cells[0, 1] = new Cell((short)1);
worksheet.Cells[2, 0] = new Cell(9999999);
worksheet.Cells[3, 3] = new Cell((decimal)3.45);
worksheet.Cells[2, 2] = new Cell("Text string");
worksheet.Cells[2, 4] = new Cell("Second string");
worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00");
//worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY-MM-DD");
worksheet.Cells.ColumnWidth[0, 1] = 3000;
workbook.Worksheets.Add(worksheet);
workbook.Save(file);
}
public Worksheet EnteteSVRLigne1(Worksheet worksheet)
{
worksheet.Cells[0, 0] = new Cell("Report date");
worksheet.Cells[0, 1] = new Cell("Pay cycle");
worksheet.Cells[0, 2] = new Cell("Country code");
worksheet.Cells[0, 3] = new Cell("Company name");
worksheet.Cells[0, 4] = new Cell("Entity ID");
worksheet.Cells[0, 5] = new Cell("Entity name");
worksheet.Cells[0, 6] = new Cell("Currency");
worksheet.Cells[0, 7] = new Cell("GL account");
worksheet.Cells[0, 8] = new Cell("GL description");
worksheet.Cells[0, 9] = new Cell("Cost center code");
worksheet.Cells[0, 10] = new Cell("Cost center description");
worksheet.Cells[0, 11] = new Cell("Amount debit");
worksheet.Cells[0, 12] = new Cell("Amount credit");
return worksheet;
}
public static void ExportXLSX(List<IParticipant> participants, List<string> formFields)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=participants-" + participants[0].EventPage.ID + ".xls");
HttpContext.Current.Response.Charset = Encoding.UTF8.WebName;
HttpContext.Current.Response.ContentEncoding = Encoding.UTF8;
HttpContext.Current.Response.BinaryWrite(Encoding.UTF8.GetPreamble());
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.BufferOutput = true;
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Participants");
if(formFields != null)
for(int i = 0; i < formFields.Count; i++)
worksheet.Cells[0, i]= new Cell(formFields[i]);
else
{
string[] headers = AttendRegistrationEngine.GetFormData(participants[0]).AllKeys;
for (int i = 0; i < headers.Length; i++)
{
worksheet.Cells[0, i] = new Cell(headers[i]);
}
}
for (int i = 0; i < participants.Count; i++)
{
AddParticipantToWorksheet(worksheet, i+1, participants[i]);
}
workbook.Worksheets.Add(worksheet);
MemoryStream ms = new MemoryStream();
workbook.SaveToStream(ms);
ms.WriteTo(HttpContext.Current.Response.OutputStream);
HttpContext.Current.Response.End();
}
private bool StreamXL(string strPath)
{
bool blSuccess = false;
Workbook xlWB = Workbook.Load(strPath);
for (int j = 0; j < xlWB.Worksheets.Count; j++)
{
ExcelLibrary.SpreadSheet.Worksheet xlSheet = xlWB.Worksheets[j];
string strName = xlSheet.Name;
strName = strName.Replace("'", "''");
bool blVerify = VerifySpreadSheet(strName);
if (blVerify == true)
{
TraverseSpreadsheet(xlSheet);
}
}
return(blSuccess);
}
public static void Main()
{
List<Student> students = GetInput();
List<Student> onlineStudentsSortedByResult = students
.Where(student => student.StudentType == "Online")
.OrderByDescending(student => student.CalculateResult())
.ToList();
// creating new workbook and sheet
const string pathToOutputFile = "../../output/outputFile.xls";
Workbook workbook = new Workbook();
Worksheet worksheet = new Worksheet("Online Students");
// adding all the students
for (int i = 0; i < onlineStudentsSortedByResult.Count; i++)
{
worksheet.Cells[i, 0] = new Cell(onlineStudentsSortedByResult[i].ID);
worksheet.Cells[i, 1] = new Cell(onlineStudentsSortedByResult[i].FirstName);
worksheet.Cells[i, 2] = new Cell(onlineStudentsSortedByResult[i].LastName);
worksheet.Cells[i, 3] = new Cell(onlineStudentsSortedByResult[i].Email);
worksheet.Cells[i, 4] = new Cell(onlineStudentsSortedByResult[i].Gender);
worksheet.Cells[i, 5] = new Cell(onlineStudentsSortedByResult[i].StudentType);
worksheet.Cells[i, 6] = new Cell(onlineStudentsSortedByResult[i].ExamResult);
worksheet.Cells[i, 7] = new Cell(onlineStudentsSortedByResult[i].HomeworkSent);
worksheet.Cells[i, 8] = new Cell(onlineStudentsSortedByResult[i].HomeworkEvaluated);
worksheet.Cells[i, 9] = new Cell(onlineStudentsSortedByResult[i].TeamworkScore);
worksheet.Cells[i, 10] = new Cell(onlineStudentsSortedByResult[i].AttendacesCount);
worksheet.Cells[i, 11] = new Cell(onlineStudentsSortedByResult[i].Bonus);
worksheet.Cells[i, 12] = new Cell(onlineStudentsSortedByResult[i].CalculateResult());
}
// saving the workbook
workbook.Worksheets.Add(worksheet);
workbook.Save(pathToOutputFile);
}
static void Main(string[] args)
{
var underTest = new Workbook();
var sheet = new Worksheet("Sheet 1");
var styleA = new CellFormat();
styleA.SetBackgroundColor(ExcelColor.Red);
styleA.Border.DiagonalUp = true;
styleA.Border.DiagonalDown = true;
styleA.Border.DiagonalStyle = CellBorderStyle.Thin;
var styleB = new CellFormat
{
Pattern =
{
Style = PatternStyle.LightDown,
ForegroundColor = ExcelColor.Blue
}
};
var styleC = new CellFormat();
styleC.SetBackgroundColor(ExcelColor.Silver);
styleC.Border = CellBorder.MediumBox;
styleC.Font.Bold = true;
for (var i = 0; i < 100; i++)
{
var cellA = new Cell("Abcde");
var cellB = new Cell(1234);
var cellC = new Cell(string.Format("This is row {0:000}", i));
if (i%2 == 0)
{
cellA.CellFormat = styleA;
cellB.CellFormat = styleB;
cellC.CellFormat = styleC;
}
else
{
cellB.CellFormat.TextControl.RotationStyle = RotationStyle.CounterClockwise;
cellB.CellFormat.TextControl.TextRotation = 45;
cellC.VerticalAlignment = VerticalAlignStyle.Centered;
cellC.CellFormat.Font.Name = "Times New Roman";
cellC.CellFormat.Font.Family = FontFamilyType.Roman;
cellC.CellFormat.Font.Height = 240;
}
sheet.Cells[i, 0] = cellA;
sheet.Cells[i, 1] = cellB;
sheet.Cells[i, 2] = cellC;
sheet.Cells.ColumnWidth[2] = 256 * 15;
}
underTest.Worksheets.Add(sheet);
var filename = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory), "test.xls");
if (File.Exists(filename))
{
File.Delete(filename);
}
underTest.Save(filename);
}
