Locked Cells, Formulas, & CSV Dat

M

Mohan

Hi,

We are using office web component 10 client side.

I load my object and bind the xmlurl (as a template).
Next I want to load csv data that I saved from a previous session that
was saved to a sql database.

The spreadsheet is protected and has locked and unlocked cells. I
can not use "csvdata" meathod to load the data because it
will override the xml template already loaded. I can not use
"LoadText" method because it tries to write back the values that were
derived from the excel
spreadsheet in the previous session and those cells are locked.

Is there any way that I can save data, as a whole, into a sql data and
load it back without trying to override my orginal formulas?? What I
don't want to do is have to
save and load/populate each cell individually.



for each x in f.xlSs1.Worksheets
with x
x.Protection.enabled=true
if i=1 then
f.xlSs1.sheets(1).range("A1").loadtext
"http://localhost/ECBenchmarkPricing/SIG_New1.CSV",","
elseif i=2 then
f.xlSs1.sheets(2).range("A1").loadtext
"http://localhost/ECBenchmarkPricing/SIG_New2.CSV",","
end if
i=i+1
end with
next

thanks in advance
mohan
 

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

Top