充值积分
下载资源后端资源详情
xlnt_demo.zip
大小:3.21MB
价格:15积分
下载量:0
评分:
5.0
上传者:weixin_40331125
更新日期:2020-07-24

xlnt_demo，利用C++开源库xlnt读写excel，vs2015工程

资源文件列表(大概)

文件名
大小
xlnt_demo/
-
xlnt_demo/x64/
-
xlnt_demo/x64/Release/
-
xlnt_demo/x64/Release/xlnt.dll
1.82MB
xlnt_demo/x64/Release/xlnt_demo.exe
23.5KB
xlnt_demo/x64/Release/xlnt_demo.iobj
609.91KB
xlnt_demo/x64/Release/xlnt_demo.ipdb
198.89KB
xlnt_demo/x64/Release/xlnt_demo.pdb
1.41MB
xlnt_demo/xlnt_demo/
-
xlnt_demo/xlnt_demo/bin/
-
xlnt_demo/xlnt_demo/bin/xlnt.dll
1.82MB
xlnt_demo/xlnt_demo/include/
-
xlnt_demo/xlnt_demo/include/xlnt/
-
xlnt_demo/xlnt_demo/include/xlnt/cell/
-
xlnt_demo/xlnt_demo/include/xlnt/cell/cell.hpp
21.06KB
xlnt_demo/xlnt_demo/include/xlnt/cell/cell_reference.hpp
9.62KB
xlnt_demo/xlnt_demo/include/xlnt/cell/cell_type.hpp
2.04KB
xlnt_demo/xlnt_demo/include/xlnt/cell/comment.hpp
4.7KB
xlnt_demo/xlnt_demo/include/xlnt/cell/hyperlink.hpp
2.2KB
xlnt_demo/xlnt_demo/include/xlnt/cell/index_types.hpp
9.99KB
xlnt_demo/xlnt_demo/include/xlnt/cell/phonetic_run.hpp
1.6KB
xlnt_demo/xlnt_demo/include/xlnt/cell/rich_text.hpp
5.58KB
xlnt_demo/xlnt_demo/include/xlnt/cell/rich_text_run.hpp
1.71KB
xlnt_demo/xlnt_demo/include/xlnt/drawing/
-
xlnt_demo/xlnt_demo/include/xlnt/drawing/spreadsheet_drawing.hpp
1.89KB
xlnt_demo/xlnt_demo/include/xlnt/packaging/
-
xlnt_demo/xlnt_demo/include/xlnt/packaging/ext_list.hpp
2.71KB
xlnt_demo/xlnt_demo/include/xlnt/packaging/manifest.hpp
7.56KB
xlnt_demo/xlnt_demo/include/xlnt/packaging/relationship.hpp
5KB
xlnt_demo/xlnt_demo/include/xlnt/packaging/uri.hpp
6.76KB
xlnt_demo/xlnt_demo/include/xlnt/styles/
-
xlnt_demo/xlnt_demo/include/xlnt/styles/alignment.hpp
4.92KB
xlnt_demo/xlnt_demo/include/xlnt/styles/border.hpp
6.12KB
xlnt_demo/xlnt_demo/include/xlnt/styles/color.hpp
9.7KB
xlnt_demo/xlnt_demo/include/xlnt/styles/conditional_format.hpp
4.33KB
xlnt_demo/xlnt_demo/include/xlnt/styles/fill.hpp
9.93KB
xlnt_demo/xlnt_demo/include/xlnt/styles/font.hpp
8.51KB
xlnt_demo/xlnt_demo/include/xlnt/styles/format.hpp
7.52KB
xlnt_demo/xlnt_demo/include/xlnt/styles/number_format.hpp
7.75KB
xlnt_demo/xlnt_demo/include/xlnt/styles/protection.hpp
3.4KB
xlnt_demo/xlnt_demo/include/xlnt/styles/style.hpp
8.34KB
xlnt_demo/xlnt_demo/include/xlnt/utils/
-
xlnt_demo/xlnt_demo/include/xlnt/utils/calendar.hpp
1.5KB
xlnt_demo/xlnt_demo/include/xlnt/utils/date.hpp
2.92KB
xlnt_demo/xlnt_demo/include/xlnt/utils/datetime.hpp
4.08KB
xlnt_demo/xlnt_demo/include/xlnt/utils/exceptions.hpp
9.1KB
xlnt_demo/xlnt_demo/include/xlnt/utils/numeric.hpp
6.87KB
xlnt_demo/xlnt_demo/include/xlnt/utils/optional.hpp
10.73KB
xlnt_demo/xlnt_demo/include/xlnt/utils/path.hpp
6.89KB
xlnt_demo/xlnt_demo/include/xlnt/utils/scoped_enum_hash.hpp
1.76KB
xlnt_demo/xlnt_demo/include/xlnt/utils/time.hpp
3.03KB
xlnt_demo/xlnt_demo/include/xlnt/utils/timedelta.hpp
2.55KB
xlnt_demo/xlnt_demo/include/xlnt/utils/variant.hpp
5.12KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/
-
xlnt_demo/xlnt_demo/include/xlnt/workbook/calculation_properties.hpp
2.06KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/document_security.hpp
3.34KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/external_book.hpp
1.46KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/metadata_property.hpp
2.26KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/named_range.hpp
2.99KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/streaming_workbook_reader.hpp
4.67KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/streaming_workbook_writer.hpp
3.84KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/theme.hpp
1.54KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/workbook.hpp
30.02KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/workbook_view.hpp
3.92KB
xlnt_demo/xlnt_demo/include/xlnt/workbook/worksheet_iterator.hpp
8.73KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/
-
xlnt_demo/xlnt_demo/include/xlnt/worksheet/cell_iterator.hpp
9.98KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/cell_vector.hpp
7.01KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/column_properties.hpp
2.49KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/header_footer.hpp
10.49KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/major_order.hpp
1.46KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/page_margins.hpp
3.46KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/page_setup.hpp
5.69KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/pane.hpp
2.89KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/phonetic_pr.hpp
4.5KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/print_options.hpp
2.37KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/range.hpp
9.74KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/range_iterator.hpp
8.49KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/range_reference.hpp
6.4KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/row_properties.hpp
2.88KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/selection.hpp
4.61KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/sheet_format_properties.hpp
2.29KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/sheet_pr.hpp
3.11KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/sheet_protection.hpp
2.15KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/sheet_view.hpp
6.75KB
xlnt_demo/xlnt_demo/include/xlnt/worksheet/worksheet.hpp
26.05KB
xlnt_demo/xlnt_demo/include/xlnt/xlnt.hpp
3.41KB
xlnt_demo/xlnt_demo/include/xlnt/xlnt_config.hpp
1.6KB
xlnt_demo/xlnt_demo/lib/
-
xlnt_demo/xlnt_demo/lib/cmake/
-
xlnt_demo/xlnt_demo/lib/cmake/xlnt/
-
xlnt_demo/xlnt_demo/lib/cmake/xlnt/XlntConfig.cmake
1.15KB
xlnt_demo/xlnt_demo/lib/cmake/xlnt/XlntConfigVersion.cmake
1.84KB
xlnt_demo/xlnt_demo/lib/cmake/xlnt/XlntTargets-release.cmake
866B
xlnt_demo/xlnt_demo/lib/cmake/xlnt/XlntTargets.cmake
3.25KB
xlnt_demo/xlnt_demo/lib/xlnt.lib
615.39KB
xlnt_demo/xlnt_demo/main.cpp
3.28KB
xlnt_demo/xlnt_demo/share/
-
xlnt_demo/xlnt_demo/share/man/
-
xlnt_demo/xlnt_demo/share/man/man3/
-
xlnt_demo/xlnt_demo/share/man/man3/xlnt.3
63.18KB
xlnt_demo/xlnt_demo/test_read.xlsx
8.67KB
xlnt_demo/xlnt_demo/test_save.xlsx
12.84KB
xlnt_demo/xlnt_demo/x64/
-
xlnt_demo/xlnt_demo/x64/Release/
-
xlnt_demo/xlnt_demo/x64/Release/main.obj
1.32MB
xlnt_demo/xlnt_demo/x64/Release/vc140.pdb
1.07MB
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.Build.CppClean.log
637B
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.log
449B
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/
-
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/CL.command.1.tlog
656B
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/CL.read.1.tlog
26.77KB
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/CL.write.1.tlog
354B
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/link.command.1.tlog
1.28KB
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/link.read.1.tlog
3.74KB
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/link.write.1.tlog
588B
xlnt_demo/xlnt_demo/x64/Release/xlnt_demo.tlog/xlnt_demo.lastbuildstate
196B
xlnt_demo/xlnt_demo/xlnt.dll
1.82MB
xlnt_demo/xlnt_demo/xlnt_demo.vcxproj
5.95KB
xlnt_demo/xlnt_demo/xlnt_demo.vcxproj.filters
945B
xlnt_demo/xlnt_demo/xlnt_demo.vcxproj.user
165B
xlnt_demo/xlnt_demo.sln
1.28KB

资源内容介绍

利用C++开源库xlnt读写excel的vs2015工程。详细教程参考博客：https://humfrey.blog.csdn.net/article/details/107527883
#include <iostream>#include <xlnt/xlnt.hpp>#include <vector>#include <string>void read_to_screen(std::string filepath){xlnt::workbook wb;wb.load(filepath);auto ws = wb.active_sheet();std::clog << "Processing spread sheet" << std::endl;// 会把当前占用的单元格全都打印出来，空单元格则为空格。for (auto row : ws.rows(false)){for (auto cell : row){std::clog << cell.to_string() << "\t";}std::clog << std::endl;}std::clog << "Processing complete" << std::endl;}std::vector< std::vector<std::string> > read_to_vector(std::string filepath){xlnt::workbook wb;wb.load(filepath);auto ws = wb.active_sheet();std::clog << "Processing spread sheet" << std::endl;std::clog << "Creating a single vector which stores the whole spread sheet" << std::endl;std::vector< std::vector<std::string> > theWholeSpreadSheet;for (auto row : ws.rows(false)){std::vector<std::string> aSingleRow;for (auto cell : row){aSingleRow.push_back(cell.to_string());}theWholeSpreadSheet.push_back(aSingleRow);}std::clog << "Processing complete" << std::endl << std::endl;std::clog << "Reading the vector and printing output to the screen" << std::endl;for (int rowInt = 0; rowInt < theWholeSpreadSheet.size(); rowInt++){for (int colInt = 0; colInt < theWholeSpreadSheet.at(rowInt).size(); colInt++){std::cout << theWholeSpreadSheet.at(rowInt).at(colInt) << "\t";}std::cout << std::endl;}return theWholeSpreadSheet;}void save_demo(std::string filepath){xlnt::workbook wb;xlnt::worksheet ws = wb.active_sheet();//赋值为数值ws.cell("A1").value(0.5);//设置单位格格式，设为百分比形式ws.cell("A1").number_format(xlnt::number_format::percentage());//赋值为字符串ws.cell("B2").value("string data");//赋值为公式ws.cell("C3").formula("=RAND()");//合并单元格ws.merge_cells("C3:C4");//冻结窗格ws.freeze_panes("B2");//保存wb.save(filepath);}void save_from_vector(std::string filepath){std::vector< std::vector<std::string> > wholeWorksheet;for (int outer = 0; outer < 10; outer++){std::vector<std::string> singleRow;for (int inner = 0; inner < 10; inner++){//给vector中的每个元素赋值std::string val = std::to_string(inner + 1);singleRow.push_back(val);}wholeWorksheet.push_back(singleRow);}//创建工作簿std::clog << "Creating workbook" << std::endl;xlnt::workbook wbOut;//创建工作表，并把vector中的元素写入表格xlnt::worksheet wsOut = wbOut.active_sheet();//给工作表设置名称wsOut.title("data");std::clog << "Looping through vector and writing to spread sheet" << std::endl;for (int fOut = 0; fOut < wholeWorksheet.size(); fOut++){std::clog << "Row" << fOut << std::endl;for (int fIn = 0; fIn < wholeWorksheet.at(fOut).size(); fIn++){// 给单元格赋值// 特别注意：工作表中的单元格下标是从1开始，而vector中的元素下标是从0开始wsOut.cell(xlnt::cell_reference(fIn + 1, fOut + 1)).value(wholeWorksheet.at(fOut).at(fIn));}}std::clog << "Finished writing spread sheet" << std::endl;wbOut.save(filepath);}int main(){//read_to_screen("test_read.xlsx");//read_to_vector("test_read.xlsx");//save_demo("test_save.xlsx");save_from_vector("test_save.xlsx");getchar();return 0;}

用户评论 (0)

发表评论

captcha

相关资源

openfire3.10.2缺失的jar包（修改版）

找了两三天，得到所有openfire3.10.2缺失jar包，包含7个，导入到工程即可。期间遇到很多问题，比如无法找到HTTPSPDYServerConnector类等，都已经能够解决了。

5.33MB46积分

MSP430F5529的官方例程

本文件是MSP430F5529的官方例程，虽然在官网上可以找到，但是很不好找，里面有十几个实验例程，注意代码是在solution这个文件夹里面

11.49MB15积分

System.Data.SQLite.DLL 64bit

64位运行库 SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

366.11KB20积分

CXF整合Spring需要用到的JAR包

CXF整合Spring需要用到的JAR包

7.62MB11积分