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

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members