java根据列名读取excel内容

最新推荐文章于 2024-07-30 10:02:32 发布
最新推荐文章于 2024-07-30 10:02:32 发布
阅读量2.4k 收藏 9
点赞数 1
文章标签： excel poi
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Primary_CG/article/details/105110737
版权

所需jar包：
commons-fileupload-1.31.jar
poi-3.17.jar
poi-ooxml-3.17.jar

package com.fh.util;

import java.io.FileInputStream;
import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.fileupload.disk.DiskFileItem;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.commons.CommonsMultipartFile;

import com.qlyl.db.Sql;
import com.qlyl.util.DataStore;
import com.qlyl.util.GlobalNames;

public class ObjectExcelReadCNV {
	public static List<PageData> readExcelLis(int startrow, int startcol, int sheetnum, MultipartFile file) {
		if(file.getOriginalFilename().endsWith(".xlsx")) {
			return readExcelLisForXlsx(startrow,startcol,sheetnum,file);
		}else {
			return readExcelLisForXls(startrow,startcol,sheetnum,file);
		}
	}
		
	private static List<PageData> readExcelLisForXlsx(int startrow, int startcol, int sheetnum, MultipartFile file) {
		List<PageData> varList = new ArrayList<PageData>();
		try {
			CommonsMultipartFile cFile = (CommonsMultipartFile) file;
			DiskFileItem fileItem = (DiskFileItem) cFile.getFileItem();
			InputStream inputStream = fileItem.getInputStream();
			FileInputStream fi = (FileInputStream) inputStream;
			XSSFWorkbook wb = new XSSFWorkbook(fi);
			XSSFSheet sheet = wb.getSheetAt(sheetnum); // sheet 从0开始
			int rowNum = sheet.getLastRowNum() + 1; // 取得最后一行的行号

			int sampleid = 1;
			int custname = 2;
			int sex = 3;
			int age = 4;
			int idnumber = 5;
			int telephone = 6;
			int source_agent = 7;
			int sumitunit = 8;
			int specimenkind = 9;
			int samplestatus = 10;
			int clinicaldiagnosis = 11;
			int specialcase = 12;
			int collecttime = 13;
			int receivedate = 14;
			int administrativeoffice = 15;
			int sumitname = 16;
			int patientid = 17;
			int inhosptialnum = 18;
			
			for (int i = 0; i < 1; i++) { // 取第一行标题，根据标题决定字段序列
				XSSFRow row = sheet.getRow(i);
				int cellNum = row.getLastCellNum();
				for (int j = startcol; j < cellNum; j++) {
					XSSFCell cell = row.getCell(Short.parseShort(j + ""));
					String cellValue = null;
					if (null != cell) {
						switch (cell.getCellType()) { // 判断excel单元格内容的格式，并对其进行转换，以便插入数据库
						case 0:
							if (HSSFDateUtil.isCellDateFormatted(cell)) {
								SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
								cellValue = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));
							} else {
								cellValue = String.valueOf((long) cell.getNumericCellValue());
							}
							break;
						case 1:
							cellValue = cell.getStringCellValue();
							break;
						case 2:
							cellValue = cell.getNumericCellValue() + "";
							break;
						case 3:
							cellValue = "";
							break;
						case 4:
							cellValue = String.valueOf(cell.getBooleanCellValue());
							break;
						case 5:
							cellValue = String.valueOf(cell.getErrorCellValue());
							break;
						}
					} else {
						cellValue = "";
					}
					if (cellValue.equalsIgnoreCase("样本编号") || cellValue.equalsIgnoreCase("样品编号")) { 
						sampleid = j;
					}
					if (cellValue.equalsIgnoreCase("姓名")) { 
						custname = j;
					}
					if (cellValue.equalsIgnoreCase("性别")) { 
						sex = j;
					}
					if (cellValue.equalsIgnoreCase("年龄")) { 
						age = j;
					}
					if (cellValue.equalsIgnoreCase("身份证号")) { 
						idnumber = j;
					}
					if (cellValue.equalsIgnoreCase("手机号")) { 
						telephone	 = j;
					}
					if (cellValue.equalsIgnoreCase("样本来源")) { 
						source_agent = j;
					}
					if (cellValue.equalsIgnoreCase("采样单位")) { 
						sumitunit = j;
					}
					if (cellValue.equalsIgnoreCase("标本种类")) { 
						specimenkind = j;
					}
					if (cellValue.equalsIgnoreCase("标本状态")) { 
						samplestatus = j;
					}
					if (cellValue.equalsIgnoreCase("临床诊断")) { 
						clinicaldiagnosis = j;
					}
					if (cellValue.equalsIgnoreCase("特殊情况")) { 
						specialcase = j;
					}
					if (cellValue.equalsIgnoreCase("采样时间")) { 
						collecttime = j;
					}
					if (cellValue.equalsIgnoreCase("接收时间")) { 
						receivedate = j;
					}
					if (cellValue.equalsIgnoreCase("科别")) { 
						administrativeoffice = j;
					}
					if (cellValue.equalsIgnoreCase("申请医生")) { 
						sumitname = j;
					}
					if (cellValue.equalsIgnoreCase("病人ID")) { 
						patientid = j;
					}
					if (cellValue.equalsIgnoreCase("门诊/住院号")) { 
						inhosptialnum = j;
					}
					
				}
			}
			for (int i = startrow; i < rowNum; i++) { // 行循环开始

				PageData varpd = new PageData();
				boolean isExist = true;
				XSSFRow row = sheet.getRow(i); // 行
				int cellNum = row.getLastCellNum(); // 每行的最后一个单元格位置
				for (int j = startcol; j < cellNum; j++) { // 列循环开始

					XSSFCell cell = row.getCell(Short.parseShort(j + ""));
					String cellValue = null;
					if (null != cell) {
						switch (cell.getCellType()) { // 判断excel单元格内容的格式，并对其进行转换，以便插入数据库
						case 0:
							if (HSSFDateUtil.isCellDateFormatted(cell)) {
								SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
								cellValue = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));
							} else {
								cellValue = String.valueOf((long) cell.getNumericCellValue());
							}
							break;
						case 1:
							cellValue = cell.getStringCellValue();
							break;
						case 2:
							cellValue = cell.getNumericCellValue() + "";
							break;
						case 3:
							cellValue = "";
							break;
						case 4:
							cellValue = String.valueOf(cell.getBooleanCellValue());
							break;
						case 5:
							cellValue = String.valueOf(cell.getErrorCellValue());
							break;
						}
					} else {
						cellValue = "";
					}
					if (j == sampleid) {
						if (StringUtils.isEmpty(cellValue)) {
							isExist = false;
							break;
						}
						varpd.put("sampleid", cellValue.trim());
						varpd.put("is_bloodagain", GlobalNames.IS_NO);
					}
					if (j == custname) {
						if (StringUtils.isEmpty(cellValue)) {
							isExist = false;
							break;
						}
						varpd.put("custname", cellValue.trim());
					}
					if (j == sex) {
						varpd.put("sex", cellValue.trim());
					}
					if (j == age) {
						varpd.put("age", cellValue.trim());
					}
					
					if (j == idnumber) {
						varpd.put("idnumber", cellValue.trim());
					}
					if (j == telephone) {
						varpd.put("telephone", cellValue.trim());
					}
					if (j == source_agent) {
						varpd.put("source_agent", cellValue.trim());
					}
					if (j == sumitunit) {
						varpd.put("sumitunit", cellValue.trim());
					}
					if (j == specimenkind) {
						Sql sql = new Sql();
						sql.setSql("select t.codename from sys_code t where codeid = ? and codekey = ?");
						sql.setString(1, cellValue.trim());
						sql.setString(2, "标本种类表");
						DataStore executeQuery = sql.executeQuery();
						if(executeQuery.size() > 0) {
							String codename = executeQuery.getString(0, "codename").trim();
							varpd.put("specimenkind", codename);
						}else {
							varpd.put("specimenkind", cellValue.trim());
						}
					}
					if (j == samplestatus) {
						varpd.put("samplestatus", cellValue.trim());
					}
					if (j == clinicaldiagnosis) {
						varpd.put("clinicaldiagnosis", cellValue.trim());
					}
					if (j == specialcase) {
						varpd.put("specialcase", cellValue.trim());
					}
					if (j == collecttime) {
						varpd.put("collecttime", cellValue.trim());
					}
					if (j == receivedate) {
						varpd.put("receivedate", cellValue.trim());
					}
					if (j == administrativeoffice) {
						Sql sql = new Sql();
						sql.setSql("select t.codename from sys_code t where codeid = ? and codekey = ?");
						sql.setString(1, cellValue.trim());
						sql.setString(2, "病人科别表");
						DataStore executeQuery = sql.executeQuery();
						if(executeQuery.size() > 0) {
							String codename = executeQuery.getString(0, "codename").trim();
							varpd.put("administrativeoffice", codename);
						}else {
							varpd.put("administrativeoffice", cellValue.trim());
						}
					}
					if (j == sumitname) {
						varpd.put("sumitname", cellValue.trim());
					}
					if (j == patientid) {
						varpd.put("patientid", cellValue.trim());
					}
					if (j == inhosptialnum) {
						varpd.put("inhosptialnum", cellValue.trim());
					}
				}
				if (isExist) {
					varList.add(varpd);
				}
			}
			wb.close();
		} catch (Exception e) {
			e.printStackTrace();
		}

		return varList;
	
	}
		
	private static List<PageData> readExcelLisForXls(int startrow, int startcol, int sheetnum, MultipartFile file) {
		List<PageData> varList = new ArrayList<PageData>();
		try {
			CommonsMultipartFile cFile = (CommonsMultipartFile) file;
			DiskFileItem fileItem = (DiskFileItem) cFile.getFileItem();
			InputStream inputStream = fileItem.getInputStream();
			FileInputStream fi = (FileInputStream) inputStream;
			HSSFWorkbook wb = new HSSFWorkbook(fi);
			HSSFSheet sheet = wb.getSheetAt(sheetnum); // sheet 从0开始
			int rowNum = sheet.getLastRowNum() + 1; // 取得最后一行的行号

			int sampleid = 1;
			int custname = 2;
			int sex = 3;
			int age = 4;
			int idnumber = 5;
			int telephone = 6;
			int source_agent = 7;
			int sumitunit = 8;
			int specimenkind = 9;
			int samplestatus = 10;
			int clinicaldiagnosis = 11;
			int specialcase = 12;
			int collecttime = 13;
			int receivedate = 14;
			int administrativeoffice = 15;
			int sumitname = 16;
			int patientid = 17;
			int inhosptialnum = 18;
			
			for (int i = 0; i < 1; i++) { // 取第一行标题，根据标题决定字段序列
				HSSFRow row = sheet.getRow(i); // 行
				int cellNum = row.getLastCellNum();
				for (int j = startcol; j < cellNum; j++) {
					@SuppressWarnings("deprecation")
					HSSFCell cell = row.getCell(Short.parseShort(j + ""));
					String cellValue = null;
					if (null != cell) {
						switch (cell.getCellType()) { // 判断excel单元格内容的格式，并对其进行转换，以便插入数据库
						case 0:
							if (HSSFDateUtil.isCellDateFormatted(cell)) {
								SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
								cellValue = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));
							} else {
								cellValue = String.valueOf((long) cell.getNumericCellValue());
							}
							break;
						case 1:
							cellValue = cell.getStringCellValue();
							break;
						case 2:
							cellValue = cell.getNumericCellValue() + "";
							break;
						case 3:
							cellValue = "";
							break;
						case 4:
							cellValue = String.valueOf(cell.getBooleanCellValue());
							break;
						case 5:
							cellValue = String.valueOf(cell.getErrorCellValue());
							break;
						}
					} else {
						cellValue = "";
					}
					if (cellValue.equalsIgnoreCase("样本编号") || cellValue.equalsIgnoreCase("样品编号")) { 
						sampleid = j;
					}
					if (cellValue.equalsIgnoreCase("姓名")) { 
						custname = j;
					}
					if (cellValue.equalsIgnoreCase("性别")) { 
						sex = j;
					}
					if (cellValue.equalsIgnoreCase("年龄")) { 
						age = j;
					}
					if (cellValue.equalsIgnoreCase("身份证号")) { 
						idnumber = j;
					}
					if (cellValue.equalsIgnoreCase("手机号")) { 
						telephone	 = j;
					}
					if (cellValue.equalsIgnoreCase("样本来源")) { 
						source_agent = j;
					}
					if (cellValue.equalsIgnoreCase("采样单位")) { 
						sumitunit = j;
					}
					if (cellValue.equalsIgnoreCase("标本种类")) { 
						specimenkind = j;
					}
					if (cellValue.equalsIgnoreCase("标本状态")) { 
						samplestatus = j;
					}
					if (cellValue.equalsIgnoreCase("临床诊断")) { 
						clinicaldiagnosis = j;
					}
					if (cellValue.equalsIgnoreCase("特殊情况")) { 
						specialcase = j;
					}
					if (cellValue.equalsIgnoreCase("采样时间")) { 
						collecttime = j;
					}
					if (cellValue.equalsIgnoreCase("接收时间")) { 
						receivedate = j;
					}
					if (cellValue.equalsIgnoreCase("科别")) { 
						administrativeoffice = j;
					}
					if (cellValue.equalsIgnoreCase("申请医生")) { 
						sumitname = j;
					}
					if (cellValue.equalsIgnoreCase("病人ID")) { 
						patientid = j;
					}
					if (cellValue.equalsIgnoreCase("门诊/住院号")) { 
						inhosptialnum = j;
					}
				}
			}
			for (int i = startrow; i < rowNum; i++) { // 行循环开始

				PageData varpd = new PageData();
				boolean isExist = true;
				HSSFRow row = sheet.getRow(i); // 行
				int cellNum = row.getLastCellNum(); // 每行的最后一个单元格位置
				for (int j = startcol; j < cellNum; j++) { // 列循环开始

					@SuppressWarnings("deprecation")
					HSSFCell cell = row.getCell(Short.parseShort(j + ""));
					String cellValue = null;
					if (null != cell) {
						switch (cell.getCellType()) { // 判断excel单元格内容的格式，并对其进行转换，以便插入数据库
						case 0:
							if (HSSFDateUtil.isCellDateFormatted(cell)) {
								SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
								cellValue = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue()));
							} else {
								cellValue = String.valueOf((long) cell.getNumericCellValue());
							}
							break;
						case 1:
							cellValue = cell.getStringCellValue();
							break;
						case 2:
							cellValue = cell.getNumericCellValue() + "";
							break;
						case 3:
							cellValue = "";
							break;
						case 4:
							cellValue = String.valueOf(cell.getBooleanCellValue());
							break;
						case 5:
							cellValue = String.valueOf(cell.getErrorCellValue());
							break;
						}
					} else {
						cellValue = "";
					}
					if (j == sampleid) {
						if (StringUtils.isEmpty(cellValue)) {
							isExist = false;
							break;
						}
						varpd.put("sampleid", cellValue.trim());
						varpd.put("is_bloodagain", GlobalNames.IS_NO);
					}
					if (j == custname) {
						if (StringUtils.isEmpty(cellValue)) {
							isExist = false;
							break;
						}
						varpd.put("custname", cellValue.trim());
					}
					if (j == sex) {
						varpd.put("sex", cellValue.trim());
					}
					if (j == age) {
						varpd.put("age", cellValue.trim());
					}
					
					if (j == idnumber) {
						varpd.put("idnumber", cellValue.trim());
					}
					if (j == telephone) {
						varpd.put("telephone", cellValue.trim());
					}
					if (j == source_agent) {
						varpd.put("source_agent", cellValue.trim());
					}
					if (j == sumitunit) {
						varpd.put("sumitunit", cellValue.trim());
					}
					if (j == specimenkind) {
						Sql sql = new Sql();
						sql.setSql("select t.codename from sys_code t where codeid = ? and codekey = ?");
						sql.setString(1, cellValue.trim());
						sql.setString(2, "标本种类表");
						DataStore executeQuery = sql.executeQuery();
						if(executeQuery.size() > 0) {
							String codename = executeQuery.getString(0, "codename").trim();
							varpd.put("specimenkind", codename);
						}else {
							varpd.put("specimenkind", cellValue.trim());
						}
					}
					if (j == samplestatus) {
						varpd.put("samplestatus", cellValue.trim());
					}
					if (j == clinicaldiagnosis) {
						varpd.put("clinicaldiagnosis", cellValue.trim());
					}
					if (j == specialcase) {
						varpd.put("specialcase", cellValue.trim());
					}
					if (j == collecttime) {
						varpd.put("collecttime", cellValue.trim());
					}
					if (j == receivedate) {
						varpd.put("receivedate", cellValue.trim());
					}
					if (j == administrativeoffice) {
						Sql sql = new Sql();
						sql.setSql("select t.codename from sys_code t where codeid = ? and codekey = ?");
						sql.setString(1, cellValue.trim());
						sql.setString(2, "病人科别表");
						DataStore executeQuery = sql.executeQuery();
						if(executeQuery.size() > 0) {
							String codename = executeQuery.getString(0, "codename").trim();
							varpd.put("administrativeoffice", codename);
						}else {
							varpd.put("administrativeoffice", cellValue.trim());
						}
					}
					if (j == sumitname) {
						varpd.put("sumitname", cellValue.trim());
					}
					if (j == patientid) {
						varpd.put("patientid", cellValue.trim());
					}
					if (j == inhosptialnum) {
						varpd.put("inhosptialnum", cellValue.trim());
					}
				}
				if (isExist) {
					varList.add(varpd);
				}
			}
			wb.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return varList;
	}
}
Primary_CG
关注
  • 1
    点赞
  • 踩
  • 9
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Java按列读取Excel内容
qq_36472439的博客
01-06 1697
import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import java.io.File; import java.io.FileInputStream; import java.io.InputStream; import java.util.ArrayList; public class ExcelUtil { pub...
java获取excel的列名_使用java excel api怎样读取excel的列名
weixin_30094815的博客
02-19 1894
import jxl.*;import jxl.format.UnderlineStyle;import jxl.write.*;import jxl.write.Number;import jxl.write.Boolean;import java.io.*;class excel {public excel() {}/*** 读取excel** @param filepath*/public ...
Java读取Excel第一行数据，获取表头
Javaの甘乃迪的博客
06-26 4233
Java读取Excel第一行数据，获取表头
java实现读取excel表格数据
最新发布
mh17680313750的博客
07-30 352
二、判断excle类型，并调用相应的方法。1、读取2007Excel。2、读取2003Excel。
java读取Excel文件指定列的数据
weixin_43472776的博客
06-11 9049
java读取Excel文件指定列的数据 抽取Excel文件某一列的数据（.xls .xlsx 都可），返回 String 类型的list： import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.apache.poi.ss.usermodel.*; import java.io.IOException; import java.io.InputStream; import java.util.ArrayLi
java按照列读取excel,使用java读取一列excel表
weixin_35020039的博客
03-11 993
我有一张excel表.我想编写一个方法,该方法将参数作为要读取的列号,并返回由该列中的所有数据组成的数组.然后将该列元素放在xml工作表中.我怎么写一个方法来做到这一点？解决方法:使用Apache POI.您可以在其使用页面中找到示例.Sheet sheet1 = wb.getSheetAt(0);for (Row row : sheet1) {for (Cell cell : row) {// ...
Java之按行、列读excel笔记
03-16 5681
原文 首先jar包地址：https://pan.baidu.com/s/1hrPilta 或者自己去poi官网去下载。 核心工具类 package com.beforeship.excel; import java.io.ByteArrayOutputStream; import java.io.File; import java.io.FileInputStream; im
java读取excel表
眼泪落在琴弦的博客
01-16 263
使用java技术进行excel表的读取 第一步: 导入jar包 &lt;dependency&gt; &lt;groupId&gt;org.apache.poi&lt;/groupId&gt; &lt;artifactId&gt;poi-ooxml&lt;/artifactId&gt; &lt;version&gt;3.8&lt;/version&g
JAVA读取Excel，建库建表，并生成java实体
08-23
读取Excel文件后，我们可以分析列名（cellValue）来构建数据库表结构。假设我们有一个名为"fields"的Excel列存储字段名，另一个名为"data_type"的列存储数据类型，可以创建一个SQL脚本模板： ```java ...
Java中easypoi导入excel文件列名相同的处理方案
08-19
Java中easypoi导入excel文件列名相同的处理方案 Easypoi是一个基于POI的Excel处理工具，它提供了简洁易用的API，能够快速实现Excel的导入和导出。然而，在使用Easypoi导入Excel文件时，可能会碰到列名相同的问题。...
java读取excl文件内容进行mysql自动创建表
10-29
本篇将深入探讨如何利用Java读取Excel文件内容，并自动根据这些内容在MySQL数据库中创建相应的表。 首先，我们需要了解Java中用于读取Excel文件的库。Apache POI是一个流行的选择，它提供了对Microsoft Office格式...
Java读取Excel文件
10-15
java使用的jpoi读取execl文件 该资源含有最新的poi的jar包 可以用来读取execlxls xlsx两种格式 里面含有代码可以直接运行
java获取excel具体一列
11-29
使用java代码获取excel的.xls和.xlsx 两种格式的具体一列
用Java程序读取Excel表格内容并显示在Swing中
01-04
2. **读取Excel内容** 使用Apache POI，你可以创建一个` FileInputStream`对象来打开Excel文件，然后通过`WorkbookFactory`创建相应的`Workbook`对象。`Workbook`对象代表整个Excel工作簿。例如： ```java File ...
使用java 实现根据Excel内容的列名导入数据
weixin_45289158的博客
06-03 1567
1.前端代码 代码如下： //选择文件按钮 $("#btn_import").on("click", function() { // 取得上传文件 form = $("<form id= 'uploadFile' enctype='multipart/form-data' method='post'></form>"); input1 = $("<input id='fileName' type='file' nam
java读取excel内容
zhaoshuai_01的博客
07-09 1125
使用JAVA代码读取excel内容 前段时间，由于公司需要进行excel的导入导出，系统复习了一下POI的使用，详细内容如下： 代码如下： public class POITest { private static Workbook wb; private static Sheet sheet; private static final String EXCEL_X...
Java读取excel指定行列的数据（poi的方式）
热门推荐
我不是攻城狮的博客
10-21 1万+
Java读取指定行列的数据（使用poi的方式）
Java EasyExcel指定列的下标或列名读取Excel数据方法及示例代码
weixin_42098295的博客
07-02 4439
本文主要介绍Java中，使用EasyExcel通过指定列的下标或列名读取Excel(.xls,.xlsx)数据，以及使用示例代码。 原文地址：Java EasyExcel指定列的下标或列名读取Excel数据方法及示例代码
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值