Home
We need your feedback!

Bytescout Spreadsheet SDK for .NET
Screenshots

Click to view sample
Click to view sample
Click to view sample
Click to view sample
Click to view sample
Click to view sample
Click to view sample Click to view sample
Subscribe to Our Bi-Monthly Newsletter (tips, new releases, specials):
 Subscribe in a reader
 PRODUCTS  |  DOWNLOAD  |  PURCHASE  |  SUPPORT  |  TESTIMONIALS   |  NEWS  | 

Bytescout Spreadsheet SDK for .NET

Download Free Trial Buy Now More Information
Shop Safely: Bytescout Spreadsheet SDK comes with a 30-DAY UNCONDITIONAL MONEY-BACK GUARANTEE

How to format cell to display formatted date time value in XLS spreadsheet generated/modified with using Bytescout Spreadsheet SDK

This source code sample demonstrates how to format date value in cell in spreadsheet using Bytescout Spreadsheet for .NET applications

Download example source code: bytescoutxls_date_formatting_for_cells.zip (8 KB)

Output spreadsheet (XLS) screenshot:

Values with date formatted in spreadsheet

using System;
using System.Collections.Generic;
using System.Text;
using System.Diagnostics;
using Bytescout.Spreadsheet;

namespace HelloWorld
{
class Program
{
static void Main(string[] args)
{
// Create new Spreadsheet
Spreadsheet document = new Spreadsheet();

// Get worksheet by name
Worksheet worksheet = document.Workbook.Worksheets.Add("Sample");

// Set captions
worksheet.Cell(0, 0).Value = "#";
worksheet.Cell(0, 1).Value = "Date";

for (int i = 1; i < 8; i++)
{
// Set number
worksheet.Cell(i, 0).Value = i;

// Set current cell
Cell currentCell = worksheet.Cell(i, 1);

// Set date. This is days since 01.01.1900
// You can also convert number to date time using the function: DateTime.FromOADate(double d)
currentCell.Value = 30000 + i * 1000;

// Set date format
currentCell.NumberFormat = "dd.mm.yyyy";
}

// Save document
document.SaveAs("Sample.xls");

// Close document
document.Close();

// open generated XLS document in default program
Process.Start("Sample.xls");
}
}
}

Download example source code: bytescoutxls_date_formatting_for_cells.zip (8 KB)

Download Free Trial Buy Now More Information
Shop Safely: Bytescout Spreadsheet SDK comes with a 30-DAY UNCONDITIONAL MONEY-BACK GUARANTEE

Documentation online: view (separate window)

First steps tutorials:

Advanced Examples:

HOME  |  CONTACT US

Copyright © ByteScout, 2003-2010. Privacy Statement
Microsoft®, Windows®, Windows 2000®, Windows Server®, Windows Vista®, Internet Explorer®, .NET Framework®, ActiveX®, Visual Basic®, Visual C#®, ASP®, ASP.NET®, Excel®, PowerPoint®, are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Adobe®, Flash® and Acrobat® are registered trademarks of Adobe Systems, Incorporated. Mozilla®, Firefox® and the Mozilla and Firefox Logos are registered trademarks of the Mozilla Foundation. Other product names or brandnames used herein are for identification purposes only and might be trademarks or registered trademarks of their respective companies. We disclaim any and all rights to those marks.