Collapse All Expand All

To format the cells of a book, complete the following steps:

In XAML View

1. Right-click References in the Solution Explorer and select Add Reference from the list.

2. In XAML View, place your cursor between the <Grid> </Grid> tags.

3. Add two standard Button controls and one standard TextBox control to the page.

1. Edit the markup for the first button so that it resembles the following:

Markup	Copy Code
<Button x:Name="HelloButton" Content="Click Hello" />

2. Edit the markup for the second button so that it resembles the following:

Markup	Copy Code
<Button x:Name="SaveButton" Content="Save" />

3. Edit the markup for the TextBox control so that it resembles the following:

Markup	Copy Code
<TextBox Name="_tbContent" Text="Empty" IsReadOnly="True" AcceptsReturn="True" FontFamily="Courier New" Background="White" Margin="465,10,242,722" />

4. Double-click the HelloButton to switch to the code view of MainPage.xaml. This will also add a HelloButton_Click event to the code.

5. Switch back to Design View and double-click the SaveButton to add a SaveButton_Click event to the code. This will open the Code View.

In Code View

1. Add a using statement to the top of the page:

C#	Copy Code
using C1.Xaml.Excel;

2. Add the following code to the MainPage class so that it resembles the following:

C#	Copy Code
public sealed partial class MainPage : Page { C1XLBook _book; }

3. Create a C1XLBook by adding the following code to the InitializeComponent() method:

C#	Copy Code
_book = new C1XLBook();

4. Add the RefreshView() method. You will call this method later in the code:

C#	Copy Code
void RefreshView() { }

5. Get the sheet that was created by default and give it a name.
6. Add some content to the workbook, create a new style and apply the styles to the cells.

C#

Copy Code

private void HelloButton_Click(object sender, RoutedEventArgs e) { // step 1: create a new workbook _book = new C1XLBook(); // step 2: get the sheet that was created by default, give it a name XLSheet sheet = _book.Sheets[0]; sheet.Name = "Hello World"; // step 3: set the forecolor and backcolor properties and add some formatting to the cells. XLStyle style1 = new XLStyle(_book); style1.ForeColor = Colors.Yellow; style1.BackColor = Colors.Blue; style1.Format = "$ .00"; // step 4: write content and format into some cells int i; for (i = 0; i <= 9; i++) { sheet[i, 0].Value = i + 1; sheet[i, 0].Style = style1; }

7. Save the workbook.

C#

Copy Code

async void SaveButton_Click(object sender, RoutedEventArgs e) { Debug.Assert(_book != null); var picker = new Windows.Storage.Pickers.FileSavePicker(); picker.SuggestedStartLocation = Windows.Storage.Pickers.PickerLocationId.DocumentsLibrary; picker.FileTypeChoices.Add("Open XML Excel file", new List<string>() { ".xlsx" }); picker.FileTypeChoices.Add("BIFF Excel file", new List<string>() { ".xls" }); picker.SuggestedFileName = "New Book"; var file = await picker.PickSaveFileAsync(); if (file != null) { try { // step 1: save file var fileFormat = Path.GetExtension(file.Path).Equals(".xls") ? FileFormat.Biff8 : FileFormat.OpenXml; await _book.SaveAsync(file, fileFormat); // step 2: user feedback _tbContent.Text = string.Format("File has been saved to: {0}.", file.Path); RefreshView(); } catch (Exception x) { _tbContent.Text = string.Format("EXCEPTION: {0}", x.Message); } } }

 

When you open the file you've saved, it should resemble the following image:

 

 

---

Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum  |  Documentation Feedback