package com.primecredit.dayend;
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.MalformedURLException;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import jcifs.smb.SmbException;
import jcifs.smb.SmbFile;
import jcifs.smb.SmbFileInputStream;
import jcifs.smb.SmbFileOutputStream;
import org.apache.log4j.Logger;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import com.primecredit.common.LoggerServiceFactory;
import com.primecredit.common.Parameter;
import com.primecredit.connection.ConnectionManager;
import com.primecredit.exception.LoanWebException;
import com.primecredit.los.DAOManager.ProposalManager;
/**
* @author hongk
* @date 2017-7-31
* @description **********************
*/
public class FinOverdueCustomerImageDataController extends BaseController{
protected static Logger logger=LoggerServiceFactory.getInstance().getLogger("dayend");
private ConnectionManager connMgr = null;
public FinOverdueCustomerImageDataController(ConnectionManager connMgr){
this.connMgr = connMgr;
}
/**
* 解析excel
* @param inputStream
* @return
*/
public static List<Map<String, String>> readExcel(Inp
解析excel表获取数据,并从远程服务器下载和上传文件
最新推荐文章于 2024-07-15 11:10:08 发布
该Java代码示例展示了如何解析Excel文件获取数据,并利用jcifs库进行远程服务器的文件下载和上传。首先,它读取Excel工作簿中的数据,然后遍历数据并根据业务逻辑操作文件。文件操作涉及通过SMB协议连接到远程服务器,检查目录,上传文件,并处理可能的异常。
摘要由CSDN通过智能技术生成