免费JavaExcel类库-FreeSpire.XLSforJava-2.2.0_freespire.xlsforjava资源-CSDN文库资源-CSDN文库

共697个文件

html：527个

java：93个

xlsx：51个

版权申诉

java

5星 · 超过95%的资源 116 浏览量 2021-11-10 01:12:04 上传评论 1 收藏 31.79MB ZIP 举报

Free Spire.XLS for Java是一款专门针对Java平台的开源Excel处理类库，它允许开发者在Java应用程序中创建、读取、修改和导出Excel文件。这个版本为2.2.0，提供了丰富的功能和易用的API，使得与Excel文件交互变得更加简单。 1. **基本功能**： - 创建新工作簿：Free Spire.XLS for Java可以让你从零开始创建全新的Excel工作簿，添加工作表，设置页眉和页脚，调整页面设置。 - 读取Excel文件：支持读取不同版本的XLS和XLSX格式的Excel文件，包括工作簿、工作表、单元格、图表等数据。 - 修改现有文件：能够编辑已有的Excel文件，例如修改单元格内容、样式、公式、图表等。 - 导出Excel：可以将工作簿导出为PDF、HTML、CSV、图片等多种格式，满足不同的输出需求。 2. **高级特性**： - 公式支持：Free Spire.XLS for Java支持Excel的所有内置函数，允许在单元格中使用公式进行计算。 - 图表操作：能够创建、编辑和格式化各种类型的图表，如柱状图、折线图、饼图等，并可以调整其样式和数据源。 - 数据验证：支持设置数据验证规则，限制用户输入的数据类型或范围。 - 图像处理：可以插入和调整Excel中的图像，包括图片和形状。 3. **API使用**： - 类库结构清晰：Free Spire.XLS for Java的API设计直观，易于理解和使用，开发者可以通过简单的代码实现复杂的Excel操作。 - 示例代码：提供的samples目录中包含了许多示例代码，涵盖了常见的操作，有助于快速上手。 - 文档支持：`Free Spire.XLS for Java.docx`可能包含详细的API文档，指导开发者如何使用类库中的各种方法和属性。 - 许可协议：`license.rtf`文件包含了该类库的许可信息，确保在合规范围内使用。 4. **应用领域**： - 数据分析：在Java项目中，可以方便地读取和处理大量Excel数据，进行统计分析。 - 报表生成：自动生成各类报表，如销售报告、财务报表等，提高工作效率。 - 数据导入导出：与数据库或其他系统集成，实现数据的导入导出功能。 - 教育与科研：在教学或研究中，用于生成实验报告、数据分析结果等。 5. **安装与集成**： - 开发者可以从lib目录中获取到所需的jar文件，将其加入到Java项目的类路径中。 - 可以通过Maven或Gradle等构建工具进行依赖管理，方便项目集成。 Free Spire.XLS for Java 2.2.0是一个功能强大的Java Excel处理工具，无论你是新手还是经验丰富的开发者，都能借助它轻松实现对Excel文件的各种操作。通过深入学习和实践，你可以充分利用这个类库来提升你的Java应用程序的Excel处理能力。

展开

资源推荐

资源详情

资源评论

收起资源包目录

免费Java Excel类库-Free Spire.XLS for Java-2.2.0 （697个子文件）

stylesheet.css 1KB

CSVToExcel.csv 910B

Free Spire.XLS for Java.docx 17KB

inherit.gif 57B

index-all.html 2.22MB

XlsWorksheet.html 252KB

XlsRange.html 188KB

XlsChart.html 141KB

XlsRangesCollection.html 136KB

XlsPageSetupBase.html 128KB

XlsChartShape.html 127KB

Workbook.html 123KB

IWorksheet.html 117KB

overview-tree.html 112KB

Worksheet.html 112KB

XlsConditionalFormat.html 104KB

ConditionalFormatWrapper.html 102KB

PrstGeomShapeType.html 100KB

XlsPivotTable.html 95KB

IXLSRange.html 95KB

XlsShapeFill.html 82KB

XlsChartDataLabels.html 81KB

XlsChartCategoryAxis.html 80KB

PaperSizeType.html 76KB

ChartTextArea.html 75KB

CellRange.html 74KB

XlsPivotField.html 74KB

XlsChartSerieDataFormat.html 73KB

XlsShape.html 71KB

CellStyleObject.html 71KB

XlsChartFormat.html 69KB

XlsArcShape.html 68KB

allclasses-frame.html 68KB

SparklineGroup.html 66KB

XlsLineShape.html 65KB

XlsValidation.html 64KB

ExcelColors.html 63KB

XlsWorksheetBase.html 63KB

AddtionalFormatWrapper.html 61KB

ExcelCommentObject.html 61KB

PicturesCollection.html 60KB

IPageSetupBase.html 60KB

XlsChartSerie.html 60KB

XlsValidationWrapper.html 60KB

XlsTextBoxShape.html 60KB

XlsChartAxis.html 59KB

allclasses-noframe.html 58KB

PivotBuiltInStyles.html 58KB

ChartSheet.html 57KB

IChart.html 56KB

XlsBuiltInDocumentProperties.html 55KB

IConditionalFormat.html 54KB

Chart.html 54KB

AutoFiltersCollection.html 53KB

XlsConditionalFormats.html 53KB

XlsChartValueAxis.html 53KB

XlsPicturesCollection.html 52KB

ExcelChartType.html 51KB

IShapeFill.html 51KB

XlsComment.html 51KB

XlsChartFrameFormat.html 50KB

XlsShapeLineFormat.html 49KB

XlsChartDataTable.html 49KB

IExtendedFormat.html 46KB

XlsChartDataLabelArea.html 45KB

XlsChartLegend.html 45KB

XlsRectangleShape.html 44KB

XlsWorksheetsCollection.html 44KB

XlsBitmapShape.html 44KB

TableBuiltInStyles.html 43KB

XlsRadioButtonShape.html 43KB

XlsPageSetup.html 42KB

XlsChartPageSetup.html 41KB

IPictures.html 41KB

package-summary.html 41KB

XlsOvalShape.html 40KB

ChartShadow.html 40KB

XlsCheckBoxShape.html 39KB

ISparklineGroup.html 39KB

XlsScrollBarShape.html 39KB

XlsPivotCache.html 39KB

XlsChartLegendArea.html 39KB

IBuiltInDocumentProperties.html 38KB

package-tree.html 37KB

XlsComboBoxShape.html 37KB

GradientPatternType.html 37KB

XlsChartTitleArea.html 37KB

IDataValidation.html 36KB

ExcelFont.html 36KB

ChartPageSetup.html 36KB

FilterColumn.html 36KB

IChartCategoryAxis.html 35KB

XlsChartWallOrFloor.html 35KB

ChartCategoryAxis.html 35KB

XlsSpinnerShape.html 35KB

XlsListBoxShape.html 34KB

IChartSerie.html 34KB

DocumentProperty.html 33KB

IShapeLineFormat.html 33KB

IShape.html 33KB

共 697 条

      <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--NewPage-->
<HTML>
<HEAD>
<!-- Generated by javadoc (build 1.6.0_45) on Fri Dec 13 11:19:26 CST 2019 -->
<TITLE>
Index
</TITLE>

<META NAME="date" CONTENT="2019-12-13">

<LINK REL ="stylesheet" TYPE="text/css" HREF="./stylesheet.css" TITLE="Style">

<SCRIPT type="text/javascript">
function windowTitle()
{
    if (location.href.indexOf('is-external=true') == -1) {
        parent.document.title="Index";
    }
}
</SCRIPT>
<NOSCRIPT>
</NOSCRIPT>

</HEAD>

<BODY BGCOLOR="white" onload="windowTitle();">
<HR>


<!-- ========= START OF TOP NAVBAR ======= -->
<A NAME="navbar_top"><!-- --></A>
<A HREF="#skip-navbar_top" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_top_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="./overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <FONT CLASS="NavBarFont1">Package</FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <FONT CLASS="NavBarFont1">Class</FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="./overview-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="./deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Index</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="./help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;PREV&nbsp;
&nbsp;NEXT</FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="./index.html?index-all.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="index-all.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="./allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="./allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_top"></A>
<!-- ========= END OF TOP NAVBAR ========= -->

<A HREF="#_A_">A</A> <A HREF="#_B_">B</A> <A HREF="#_C_">C</A> <A HREF="#_D_">D</A> <A HREF="#_E_">E</A> <A HREF="#_F_">F</A> <A HREF="#_G_">G</A> <A HREF="#_H_">H</A> <A HREF="#_I_">I</A> <A HREF="#_L_">L</A> <A HREF="#_M_">M</A> <A HREF="#_O_">O</A> <A HREF="#_P_">P</A> <A HREF="#_Q_">Q</A> <A HREF="#_R_">R</A> <A HREF="#_S_">S</A> <A HREF="#_T_">T</A> <A HREF="#_U_">U</A> <A HREF="#_V_">V</A> <A HREF="#_W_">W</A> <A HREF="#_X_">X</A> <HR>
<A NAME="_A_"><!-- --></A><H2>
<B>A</B></H2>
<DL>
<DT><A HREF="./com/spire/xls/CellRange.html#activate()"><B>activate()</B></A> - 
Method in class com.spire.xls.<A HREF="./com/spire/xls/CellRange.html" title="class in com.spire.xls">CellRange</A>
<DD>Active single cell in the worksheet.
<DT><A HREF="./com/spire/xls/core/IXLSRange.html#activate(boolean)"><B>activate(boolean)</B></A> - 
Method in interface com.spire.xls.core.<A HREF="./com/spire/xls/core/IXLSRange.html" title="interface in com.spire.xls.core">IXLSRange</A>
<DD>Activates a single cell, which must be inside the current selection.
<DT><A HREF="./com/spire/xls/core/spreadsheet/collections/XlsRangesCollection.html#activate(boolean)"><B>activate(boolean)</B></A> - 
Method in class com.spire.xls.core.spreadsheet.collections.<A HREF="./com/spire/xls/core/spreadsheet/collections/XlsRangesCollection.html" title="class in com.spire.xls.core.spreadsheet.collections">XlsRangesCollection</A>
<DD>Activages a single cell, scroll to it and activates the respective sheet
 To select a range of cells, use the Select method.
<DT><A HREF="./com/spire/xls/core/spreadsheet/XlsRange.html#activate(boolean)"><B>activate(boolean)</B></A> - 
Method in class com.spire.xls.core.spreadsheet.<A HREF="./com/spire/xls/core/spreadsheet/XlsRange.html" title="class in com.spire.xls.core.spreadsheet">XlsRange</A>
<DD>Activates a single cell, scroll to it and activates the corresponding sheet.
<DT><A HREF="./com/spire/xls/core/spreadsheet/XlsRange.html#activate()"><B>activate()</B></A> - 
Method in class com.spire.xls.core.spreadsheet.<A HREF="./com/spire/xls/core/spreadsheet/XlsRange.html" title="class in com.spire.xls.core.spreadsheet">XlsRange</A>
<DD>Active single cell in the worksheet
<DT><A HREF="./com/spire/xls/core/spreadsheet/XlsWorksheetBase.html#activate()"><B>activate()</B></A> - 
Method in class com.spire.xls.core.spreadsheet.<A HREF="./com/spire/xls/core/spreadsheet/XlsWorksheetBase.html" title="class in com.spire.xls.core.spreadsheet">XlsWorksheetBase</A>
<DD>Makes the current sheet the active sheet.
<DT><A HREF="./com/spire/xls/charts/ChartFormatCollection.html#add(com.spire.xls.charts.ChartFormat)"><B>add(ChartFormat)</B></A> - 
Method in class com.spire.xls.charts.<A HREF="./com/spire/xls/charts/ChartFormatCollection.html" title="class in com.spire.xls.charts">ChartFormatCollection</A>
<DD>&nbsp;
<DT><A HREF="./com/spire/xls/charts/ChartSeries.html#add(com.spire.xls.charts.ChartSerie)"><B>add(ChartSerie)</B></A> - 
Method in class com.spire.xls.charts.<A HREF="./com/spire/xls/charts/ChartSeries.html" title="class in com.spire.xls.charts">ChartSeries</A>
<DD>Adds series to the collection.
<DT><A HREF="./com/spire/xls/charts/ChartSeries.html#add()"><B>add()</B></A> - 
Method in class com.spire.xls.charts.<A HREF="./com/spire/xls/charts/ChartSeries.html" title="class in com.spire.xls.charts">ChartSeries</A>
<DD>Defines a new series.
<DT><A HREF="./com/spire/xls/charts/ChartSeries.html#add(java.lang.String)"><B>add(String)</B></A> - 
Method in class com.spire.xls.charts.<A HREF="./com/spire/xls/charts/ChartSeries.html" title="class in com.spire.xls.charts">ChartSeries</A>
<DD>Defines a new series.
<DT><A HREF="./com/spire/xls/charts/ChartSeries.html#add(com.spire.xls.ExcelChartType)"><B>add(ExcelChartType)</B></A> - 
Method in class com.spire.xls.charts.<A HREF="./com/spire/xls/charts/ChartSeries.html" title="class in com.spire.xls.charts">ChartSeries</A>
<DD>Defines a new series.
<DT><A HREF="./com/spire/xls/charts/ChartSeries.html#add(java.lang.String, com.spire.xls.ExcelChartType)"><B>add(String, ExcelChartType)</B></A> - 
Method in class com.spire.xls.charts.<A HREF="./com/spire/xls/charts/ChartSeries.html" title="class in com.spire.xls.charts">ChartSeries</A>
<DD>Defines a new series.
<DT><A HREF="./com/spire/xls/collections/ChartsCollection.html#add()"><B>add()</B></A> - 
Method in class com.spire.xls.collections.<A HREF="./com/spire/xls/collections/ChartsCollection.html" title="class in com.spire.xls.collections">ChartsCollection</A>
<DD>Adds a new chart.
<DT><A HREF="./com/spire/xls/collections/ChartsCollection.html#add(java.lang.String)"><B>add(String)</B></A> - 
Method in class com.spire.xls.collections.<A HREF="./com/spire/xls/collections/ChartsCollection.html" title="class in com.spire.xls.collections">ChartsCollection</A>
<DD>Add a new chart with name.
<DT><A HREF="./com/spire/xls/collections/ChartsCollection.html#add(com.spire.xls.ChartSheet)"><B>add(ChartSheet)</B></A> - 
Method in class com.spire.xls.collections.<A HREF="./com/spire/xls/collections/ChartsCollection.html" title="class in com.spire.xls.collections">ChartsCollection</A>
<DD>Adds chart to the collection.
<DT><A HREF="./com/spire/xls/collections/H