Microsoft Office Spreadsheet com component

[Paulers]

Hello,

I need a way to embed an editable Excel worksheet in my vb.net
applicaion so my users can input data. One of the main reasons I would
like to use the excel worksheet is to allow them to paste long lists of
numbers into multiple columns. I wish to then collect the data in the
applcation and process it. I have created a new project and was able to
use the control in my form however, I do not know how to extract any
data from from it. Can anyone point me to some examples or
documentation that will assist me. Any help would be most appreciated.
Thanks!

 

[Paulers]

I just purchased Alvin Bruney's book "The Microsoft Office Web
Components Black Book with .NET" from LULU.com , hoping to learn more
about using the spreadsheet com object. Does anyone know if it contains
vb.net examples?

 

[Alvin Bruney [Microsoft MVP]]

each sample has vb.net and c#. scripting examples come in javascript and
vbscript. chapter 8 shows detailed code on how to solve your data pasting
problem.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc

 

[Paulers]

Thanks for the response Alvin, I can't wait to get the book. Every
review I have read about it has been an great one. I have the
spreadsheet component working however it appears that between v9 and
v10 the Auto column width feature disappeared. Is there an equivelant
in v10?

 

[Alvin Bruney [Microsoft MVP]]

It's still there, i believe it is called autofit (if memory serves me
correct). The effect is to adjust the size of the column to the cell that
contains the longest text width.

Every

review I have read about it has been an great one.

Really? I heard it sucked...naw just kidding. I've gotten a lot of good feed
back as well.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc

 

[Paulers]

Hi Alvin,

I am trying to use .AutoFitColumns() with v10 spreadsheed object and I
get these errors when I compile:

Public member 'AutoFitColumns' on type 'RangeClass' not found.

any ideas?

 

[Alvin Bruney [Microsoft MVP]]

try spreadsheet1.AutoFit = true

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc

 

[Paulers]

I gave that a try. I did not get an error however the columns were not
autofitted