In This Topic
To format the cells of a book, complete the following steps:
In XAML View
- Right-click References in the Solution Explorer and select Add Reference from the list.
- Browse to find C1.UWP.Excel.dll.
- Click OK to add the assembly reference to your application.
- In XAML View, place your cursor between the <Grid> </Grid> tags.
- Add two standard Button controls and one standard TextBox control to the page.
- Edit the markup for the first button so that it resembles the following:
| Markup |
Copy Code
|
<Button x:Name="HelloButton" Content="Click Hello" />
|
- Edit the markup for the second button so that it resembles the following:
| Markup |
Copy Code
|
<Button x:Name="SaveButton" Content="Save" />
|
- 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" />
|
- Create an event named HelloButton_Click for HelloButton and switch to the code view of MainPage.xaml. This will also add a HelloButton_Click event to the code.
- 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
- Add a using statement to the top of the page:
| C# |
Copy Code
|
using C1.Xaml.Excel;
|
- 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;
}
|
- Create a C1XLBook by adding the following code to the InitializeComponent() method:
| C# |
Copy Code
|
_book = new C1XLBook();
|
- Add the RefreshView() method. You will call this method later in the code:
| C# |
Copy Code
|
void RefreshView()
{
}
|
- Get the sheet that was created by default and give it a name.
- 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;
}
|
- 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:
See Also
