Our MS Excel Library is in open beta since about one month now. This is not only the occasion to fix issues but also to confront the tool with differents users and how they are using it.

This is a good opportunity to improve the tool with users experience.

 

This past month we have added powerful commands for finding cells in a worksheet:

  • XCEL_Sheet_LastFilledCell_Get which returns the last filled cell in a worksheet
  • XCEL_Column_LastFilledCell_Get which returns the last filled cell in a column
  • XCEL_Row_LastFilledCell_Get which returns the last filled row in a column
  • XCEL_Sheet_Find which returns a list of all the cells containing a specified value, formula or comment

We have also added commands for dealing with print settings: page orientation, headers, footers, etc. It is for example possible to add a text or an image in the worksheet header or footer.

As a great improvement for Windows users, we are happy to announce we are now supporting saving workbooks in PDF formats (MS Excel 2007 or further required). This was supported for Macintosh since the first release.

In the next weeks we will add some examples to demonstrate how the tool is working and what it can do. And of course, we will continue to improve it for a final release planned for the end of October.

 

Feel free to visit our pages regularly to have news about the MS Excel Library and to send us questions or suggestions for improving the tool.