Re: Import Excel file into OWC11 in .net 2

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you Alvin for all of your help. I'm new to .NET (no surprise
there, huh?), but old to programming, so the learning curve is rather
steep right now. I searched for your book at B&N, but found I needed
to order it. I will definitely make that purchase.

Regards,

JP

Alvin Bruney [MVP] wrote:
Ok, but the design leaves a lot to be desired but working with what you have
here goes:
From a high level, you are moving the file from the client to the server
(via .net 2 fileupload) and then back to the client for *review* and then
back to the server for saving. You can see why that is ugly.

Assuming the file is located on the server (after .net2fileuload) in folder
\myfolder\file.txt. You load it into the owc control using sp.HTMLDATA =
http://server/myfolder/file.txt roughly. At this point, the user *reviews*
and makes changes. Provide the user with a save button. On save, you dump
the data into a text box control set to run on the server.
textbox1.text = sp.CSVDATA;

in your page load routine, you examine textbox1 and parse its contents to
build your query. You can see bits of the code in action by search the black
book using amazon's search feature if you care.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc

.

Quantcast