打开csv文件乱码,该怎么处理

打开csv文件乱码
将access中一个表导出到excel
然后保存为csv格式，打开后却提示“尝试打开的文件与扩展名不一致。。。”，点击确认能显示数据
用记事本打开，却显示乱码
为什么
相关代码

C/C++ code


fname=m_folder+"huizong.csv";
//fname=m_folder+"huizong";不加.csv的话就保存为xls格式，并且一切正常
objBook.SaveAs(_variant_t(fname),varFormat,covOptional,covOptional,covOptional,covOptional,0,covOptional,covOptional,covOptional,covOptional,covOptional);

m_folder保存的是路径，如果不能用这种方式保存为csv
那该怎么做

------解决方案--------------------

C/C++ code

   _ApplicationPtr pApplication = NULL ;

     WorkbooksPtr pWorkbooks = NULL ;

     _WorkbookPtr pThisWorkbook = NULL ;

     _WorksheetPtr pThisWorksheet = NULL ;

     SheetsPtr pThisSheets = NULL ;

     RangePtr pThisRange = NULL ;

     _variant_t vt ;

     VARIANT vOptional;

     vOptional.vt = VT_ERROR;

     vOptional.scode = DISP_E_PARAMNOTFOUND;  

     pApplication.CreateInstance("Excel.Application");

     pApplication->PutVisible (0,VARIANT_FALSE);

     pApplication->PutDisplayAlerts(0,VARIANT_FALSE); //不显示警告信息

     pApplication->PutAlertBeforeOverwriting(0,VARIANT_FALSE); //覆盖时不提示

 

     pWorkbooks = pApplication->GetWorkbooks() ;

     pWorkbooks->Open( "C:\\test.xls",   

         vOptional,   vOptional,   vOptional,   vOptional,   vOptional,   vOptional,   

         vOptional,   vOptional,   vOptional,   vOptional,   vOptional,   vOptional    

         );   

     pThisWorkbook = pWorkbooks->GetItem((short)1);

     pThisWorkbook->SaveAs("C:\\test.csv",_variant_t((short)Excel::xlCSV),vOptional,vOptional,_variant_t((short)FALSE),\

         vOptional,Excel::xlNoChange,vOptional,vOptional,vOptional,vOptional);

 

     pThisWorkbook->Close();

     pWorkbooks->Close();

     


     pThisWorkbook.ReleaseDispatch(); 
     pWorkbooks.ReleaseDispatch(); 
 
     pApplication->Quit();
     pApplication.ReleaseDispatch();

------解决方案--------------------
从Access到excel也是代码实现的？
你确保这个过程没有问题？

打开csv文件乱码,该怎么处理

相关推荐