Loading Excel sheet into Web component

[Rishi Dhupar]

Hi,

My goal of my VB form is to be able to select certain things and then
display a filter spreadsheet using the Excel component in Microsoft
Office Spreadsheet 10.0 control.

Can someone tell me how to load an entire excel sheet into my component
sheet? After that I should be able to figure out how to filter and
display only certain rows/columns.

Thanks,
RishiD

 

[Chip Pearson]

I think you have to loop through each cell in the worksheet.

Dim Rng As Range
Application.ScreenUpdating = False
For Each Rng In ActiveSheet.UsedRange.Cells
Sheet1.Spreadsheet1.Range(Rng.Address).Value = Rng.Value
Next Rng
Application.ScreenUpdating = True



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[NickHK]

Rishi,
Alternatively, have you looked at the OLE control to show Excel ?
It takes a little getting used to and I can't say it better than what you're
using now.

NickHK

 

[Rishi Dhupar]

Dim Rng As Range

For Each Rng In Sheet1.UsedRange.Cells
Spreadsheet1.Range((Rng.Address)).Value = Rng.Value
Next Rng


This code seems to be working well, is there anyway to keep the
formatting of the text?

Thanks so much.