471,107 Members | 1,618 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,107 software developers and data experts.

Reading/Writing to Excel BIFF file

I'm reposting this question as the other post seems to have been
sucked into the net black hole.

I'll keep this short. I am trying to read and edit an Excel workbook
in its native BIFF format. I have documentation on the BIFF format,
and a utility (Biff Edit) to view the contents of the file. As I am
new to handling binary files, does anyone have any input on how to
work with BIFF files?

Here is the output of the first record in the \Workbook stream:

IdName|Id|Size|Stream Ofs|Data|Hex
BOF|0809|16|0|....F..ɀ......|00 06 05 00 46 18 CD 07 C9 80 00 00 06
02 00 00

One of my questions is from C# how do I access this \Workbook stream?
Once I get that I suppose I just can use the offset to navigate the
other records, but I'm not sure.

Thanks everyone!

Jon Brookins
Nov 15 '05 #1
3 11906
I don't know if I can give you information about Excel Biff specifically but
from a binary file standpoint this is what you can do.

There are multiple Stream types in C# you can use. I would recommend using
a FileStream for this. From there you can read the bytes from the file.

Lookup the FileStream class in MSDN there are some examples about reading
text and binary files.

-Casey
--
Legal Disclaimer: just in case you were wondering:
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jon Brookins" <jo******@pnmi.com> wrote in message
news:fa**************************@posting.google.c om...
I'm reposting this question as the other post seems to have been
sucked into the net black hole.

I'll keep this short. I am trying to read and edit an Excel workbook
in its native BIFF format. I have documentation on the BIFF format,
and a utility (Biff Edit) to view the contents of the file. As I am
new to handling binary files, does anyone have any input on how to
work with BIFF files?

Here is the output of the first record in the \Workbook stream:

IdName|Id|Size|Stream Ofs|Data|Hex
BOF|0809|16|0|....F..?......|00 06 05 00 46 18 CD 07 C9 80 00 00 06
02 00 00

One of my questions is from C# how do I access this \Workbook stream?
Once I get that I suppose I just can use the offset to navigate the
other records, but I'm not sure.

Thanks everyone!

Jon Brookins

Nov 15 '05 #2
>I'll keep this short. I am trying to read and edit an Excel workbook
in its native BIFF format.


SyncFusion just announced a new product called "ExcelRW" which does
exactly that - handle Excel files natively, in a binary format, and
allows you to read and write those without having Excel installed
locally on the machine:

http://www.syncfusion.com/products/excelrw.aspx

Marc
================================================== ==============
Marc Scheuner May The Source Be With You!
Bern, Switzerland m.scheuner(at)inova.ch
Nov 15 '05 #3
>I'll keep this short. I am trying to read and edit an Excel workbook
in its native BIFF format.


SyncFusion just announced a new product called "ExcelRW" which does
exactly that - handle Excel files natively, in a binary format, and
allows you to read and write those without having Excel installed
locally on the machine:

http://www.syncfusion.com/products/excelrw.aspx

Marc
================================================== ==============
Marc Scheuner May The Source Be With You!
Bern, Switzerland m.scheuner(at)inova.ch
Nov 15 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by ian castleden | last post: by
7 posts views Thread by soubhagya | last post: by
1 post views Thread by mail2atulmehta | last post: by
4 posts views Thread by Li Pang | last post: by
9 posts views Thread by dba123 | last post: by
3 posts views Thread by ggupta78 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.