Tag Archives: azure

Windows Azure and OfficeWriter

Windows Azure and OfficeWriterWe’re taking OfficeWriter to the cloud. In these videos you’ll see how OfficeWriter runs on Windows Azure. Taking our exisiting OfficeWriter web sample projects, Andrew Brust from Blue Badge Insights made them run on the Windows Azure cloud platform.

In these videos you will:

  • Learn how OfficeWriter web samples were put on the cloud
  • Learn how the runtime environment for the Windows Azure samples compares to the ASP.NET samples
  • Have access to the OfficeWriter web samples




New in OfficeWriter 8.3: Auto Filters and More!

OfficeWriter 8.3 is filled with exciting new features. Here are some of our favorites:

Auto filters in ExcelApplication

Auto filters are an easy way to view and filter data in a worksheet, and now you can add them programmatically with ExcelApplication in XLSX and XLSM files!

All you need to do is create an area on the worksheet where you want the auto filter to be, then apply the auto filters to that area. This works on data sets that already have data, and data sets that just have ExcelTemplate data markers.

wksht.AutoFilter.Area = wksht.CreateArea("A6:D14");

Remember, you only get one set of auto filters per worksheet, so if you set the auto filter to a new area, you’ll lose your original filters. Continue reading New in OfficeWriter 8.3: Auto Filters and More!