Tag: spreadsheet

Feb

Specious spreadsheet security

If not for Chinese, it would’ve worked. So in Excel, you can set a password for either protecting a particular worksheet, or protecting the entire workbook/spreadsheet. This password is then hashed, and the result is stored within the spreadsheet contents. Now with the use of Open XML spreadsheets, this means the resulting hash is stored […]

Jan

SpreadsheetLight version 3

Version 3 of my spreadsheet library is now available. There’s a whole bunch of updates, including Excel 2010 conditional formatting such as data bars with negative value fill colours and icon sets with no icons. SpreadsheetLight is possibly the most developer-friendly spreadsheet library ever. Even if I do say so myself. 🙂

Nov

Calculate Excel column width pixel interval

Brace yourself. You’re about to learn the secret behind how Excel mysteriously calculates the column width intervals. In this article, I’m not going into the details of the column widths, but the column width intervals. There’s a difference. From the Open XML SDK specs: width = Truncate([{Number of Characters} * {Maximum Digit Width} + {5 […]

Aug

How to properly use OpenXmlWriter to write large Excel files

Brian Jones already wrote something on using the OpenXmlWriter with the Open XML SDK to write large Excel files. There are a couple of things that weren’t mentioned though. OpenXmlWriter works best for creating new things For the purposes of explanation, we’ll assume the “new thing” is a new worksheet, although OpenXmlWriter can be used […]

Jul

How to create an Open XML spreadsheet bar chart

Today, you’re going to learn how to insert a bar chart into an Open XML spreadsheet. Frankly speaking, the basics apply to the other types of charts, so if you master this, you can figure out how to create the other charts. First, download the source code and the resulting Excel file. I’m not going […]

Jul

Future of spreadsheets

So I was checking some site statistics for my spreadsheet library website and I found an interesting search phrase: “open xml excel future”. The person might have been checking how important spreadsheets are in the future. Or maybe just checking if Microsoft Excel is still around. Spreadsheets are still going to be used in future. […]

Jul

Setting it free

It was the hardest, most painful decision I had to make in a long while. I had worked hard on the project. I downloaded a few open-source versions of similar projects for comparison. I went through the use cases, on how to do certain tasks with those open-source projects. Then I went to a couple […]

Jul

OSBC Launch

My Open XML spreadsheet course is up! Click here for details. So here’s an interesting tidbit. Writing lesson 3 (recognising styles) was the most tedious part for me. It was unbearably boring for me. It was all I could do to slog through writing each word, coming up with screenshots and writing up example source […]