excel sheet in webpage

N

Narshe

Is there a way to have an excel sheet inside a web page? I don't mean
have it prompt for open or save, then open in the browser, but an
actual mini excel sheet that can be edited. Maybe through activex
somehow.

I've been searching and haven't really found much info on this.
 
N

Narshe

I've found a way to get an excel sheet in a web page....

<object classid="CLSID:0002E510-0000-0000-C000-000000000046">
<param name="DisplayTitleBar" value="false">
</object>

How do I retrieve data from the object now?
 
A

Alvin Bruney - ASP.NET MVP

These objects are part of the Microsoft Office Web Components tools suite.
The suite is a free download from Microsoft Office website. There are 3
versions. The latest book on the subject is listed below.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
 
N

Narshe

I actually figured out how to get the data out from a post of yours I
found from 2004 sometime....

Is there an easy way to take CSVDATA strings and convert that into a
..net datatable or something of the sort?
 
K

Kevin Spencer

Assuming that these are in files, you can use the OleDbProvider, and the
driver for text documents. The ConnectionString would look something like
this:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;Extended
Properties=""text;HDR=Yes;FMT=Delimited"""
(Courtesy of http://www.connectionstrings.com)

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.
 
N

Narshe

Thanks for the reply.

It's not in a file, it'll be in a string. I've actually made a
CsvToDataTable method to remedy my issue. I was hoping there was a more
elegant way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top