problem parsing an xls record c#
ok, let's i make sense.
i have way combined parses an comparison record works only fine. i following file:
string filetoconvert = server.mappath(".") + "\\app_data\\cp-arfjn-flag.xls";
string connectionstring = "provider=microsoft.jet.oledb.4.0;data source=" + filetoconvert + ";extended properties=excel 8.0;";
oledbconnection tie = new oledbconnection(connectionstring);
connection.open();
//this unbroken line assumes record default comparison format sheet1 initial square name, adjust accordingly
oledbdataadapter adapter = new oledbdataadapter("select * [cp-arfjn-flag$]", connection);
and works only fine. nonetheless i try tangible record (it reputed me another program) i error:
system.data.oledb.oledbexception: outmost list approaching format. during system.data.oledb.oledbconnectioninternal..ctor(oledbconnectionstring constr, oledbconnection connection) during system.data.oledb.oledbconnectionfactory.createconnection(dbconnectionoptions options, vigilant poolgroupproviderinfo, dbconnectionpool pool, dbconnection owningobject) during system.data.providerbase.dbconnectionfactory.createnonpooledconnection(dbconnection owningconnection, dbconnectionpoolgroup poolgroup) during system.data.providerbase.dbconnectionfactory.getconnection(dbconnection owningconnection) during system.data.providerbase.dbconnectionclosed.openconnection(dbconnection outerconnection, dbconnectionfactory connectionfactory) during system.data.oledb.oledbconnection.open() during wetglobe.page_load(object sender, eventargs e)
but, where i cruise problem lies. i take file, save internal excel, initial i popup:
cp-arfjn-flag.xls competence enclose features
congruous calm (tab
delimited). wish keep the
workbook format?
- to keep format, leaves
out any proud features, click
yes.
- to safety features, click no.
10 save duplicate latest excel
format.
- to competence lost, click
help.
if i click following save tide comparison format, way following work fine.
so i am presumption saved crazy aged comparison format?
i suspect questions be:
- how i tell comparison version
saved this? - how i parse the current
state? - -or- i programatically save newer version?
i wish clear... conclude you.
Comments
Post a Comment