J
JR
I imported an XML map (xsd) file into exel. I want users to enter data into
the worksheet for import into a database.
When you set up the worksheet, you have the field headings, which are
default formatted in blue with alternating blue/lightblue rows underneath.
Only one blank row is shown at the beginning.
If you want to protect the worksheet so users won't fiddle with headings and
whatnot, you must create a whole bunch of blue/lightblue rows before
protection. If you don't create enough blue/lightblue lines, the data that
spills onto nonformatted rows will not be saved in the xml file afterwards.
If you opt to add the rows before protection, unused rows show up as blank
data in the xml file.
Is seems like my only option is to distribute unprotected worksheets. Are
there alternatives?
the worksheet for import into a database.
When you set up the worksheet, you have the field headings, which are
default formatted in blue with alternating blue/lightblue rows underneath.
Only one blank row is shown at the beginning.
If you want to protect the worksheet so users won't fiddle with headings and
whatnot, you must create a whole bunch of blue/lightblue rows before
protection. If you don't create enough blue/lightblue lines, the data that
spills onto nonformatted rows will not be saved in the xml file afterwards.
If you opt to add the rows before protection, unused rows show up as blank
data in the xml file.
Is seems like my only option is to distribute unprotected worksheets. Are
there alternatives?