A
April S.
Not able to copy and paste informtion from an existing Excel spreadsheet into
a DAP setup as a spreadsheet. Help!
a DAP setup as a spreadsheet. Help!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
aaron.kempf
do you mean the OWC spreadsheet control?
that is the easiest way to do this
-aaron
that is the easiest way to do this
-aaron
A
April S.
I don't know what the OWC spreadsheet control is. Please elaborate. What I
want is for a manager to easily select specific cells in Excel and paste that
information into the DAP (spreadsheet style). Does OWC do that?
want is for a manager to easily select specific cells in Excel and paste that
information into the DAP (spreadsheet style). Does OWC do that?
A
aaron.kempf
yes, OWC will totally do that. it won't go directly into a database per
se-- but it will be a lot easier to work with; since it is all straight
xml then..
i used to work for a client that wanted this exact same thing-- i would
reccomend having them throw excel out the window.. and never look back.
DAPs rock!
-aaron
se-- but it will be a lot easier to work with; since it is all straight
xml then..
i used to work for a client that wanted this exact same thing-- i would
reccomend having them throw excel out the window.. and never look back.
DAPs rock!
-aaron
A
April S.
Still unclear exactly how to do this. Also, must continue using Excel,
required.
required.
A
aaron.kempf
NOTHING IS REQUIRED EXCEL IS A DISEASE. IF YOUR MANAGER TELLS YOU TO
INFECT YOURSELF WITH AIDS WOULD YOU DO IT?
TELL HIM THAT EXCEL IS A WASTE OF TIME AND YOU NEED TO RECREATE THIS AS
A REAL WEBPAGE.
THERE ARE NO SHORTCUTS. GARBAGE IN = GARBAGE OUT.
Just because he's got a dozen excel monkeys; typing stuff in all day
long-- that doesn't mean that it's your fault.
It's his fault for hiring worthless excel dorks in the first place.
If you really want to import a whole bunch of spreadsheets; write a
webpage to upload them to a central share; and then DTS them in. I've
written that 10 different clients.. I could probably send you some
screenshots.
Are you working for a manager with the last name of Cyr?
INFECT YOURSELF WITH AIDS WOULD YOU DO IT?
TELL HIM THAT EXCEL IS A WASTE OF TIME AND YOU NEED TO RECREATE THIS AS
A REAL WEBPAGE.
THERE ARE NO SHORTCUTS. GARBAGE IN = GARBAGE OUT.
Just because he's got a dozen excel monkeys; typing stuff in all day
long-- that doesn't mean that it's your fault.
It's his fault for hiring worthless excel dorks in the first place.
If you really want to import a whole bunch of spreadsheets; write a
webpage to upload them to a central share; and then DTS them in. I've
written that 10 different clients.. I could probably send you some
screenshots.
Are you working for a manager with the last name of Cyr?
A
April S.
Is there anyone else who can step me through how to copy and paste info from
Excel into a DAP?
Excel into a DAP?
A
aaron.kempf
yes.. you can use the Office Web Components spreadsheet control
this will put the crap from excel into xml.. then you can parse it and
do whatever you want with it.
it's all just plain old XML once it gets into Office Web Components.
OWC is a control that is included in Office; these pages can be written
with a DAP.
if i were you though; i would concentrate on IMPORTING INTO A DATABASE
using either Access or DTS.
-aaron
this will put the crap from excel into xml.. then you can parse it and
do whatever you want with it.
it's all just plain old XML once it gets into Office Web Components.
OWC is a control that is included in Office; these pages can be written
with a DAP.
if i were you though; i would concentrate on IMPORTING INTO A DATABASE
using either Access or DTS.
-aaron