读取excel中的数字到java程序中

Question

Java实现，读取excel中的数字到java程序中

Answer 1

public void batch<span class="hljs-constructor">Import(String <span class="hljs-params">fileName</span>, MultipartFile <span class="hljs-params">file</span>)</span> {
        <span class="hljs-keyword">if</span> (!fileName.matches(<span class="hljs-string">"^.+\\.(?i)(xls)$"</span>)<span class="hljs-operator"> && </span>!fileName.matches(<span class="hljs-string">"^.+\\.(?i)(xlsx)$"</span>)) {
            throw <span class="hljs-keyword">new</span> <span class="hljs-constructor">ValidateException(<span class="hljs-string">"上传文件类型不正确"</span>)</span>;
        }
        Workbook wb = null; <span class="hljs-comment">//创建工作簿</span>
        InputStream is = null;  <span class="hljs-comment">// io流</span>
        <span class="hljs-keyword">try</span> {
            is = file.get<span class="hljs-constructor">InputStream()</span>;
            wb = null;
            <span class="hljs-keyword">if</span> (!fileName.matches(<span class="hljs-string">"^.+\\.(?i)(xlsx)$"</span>)) {
                wb = <span class="hljs-keyword">new</span> <span class="hljs-constructor">HSSFWorkbook(<span class="hljs-params">is</span>)</span>; <span class="hljs-comment">// 2003版</span>
            } <span class="hljs-keyword">else</span> {
                wb = <span class="hljs-keyword">new</span> <span class="hljs-constructor">XSSFWorkbook(<span class="hljs-params">is</span>)</span>; <span class="hljs-comment">// 2007版</span>
            }
        } catch (IOException e) {
            e.print<span class="hljs-constructor">StackTrace()</span>;
        } finally {
            <span class="hljs-keyword">try</span> {
                is.close<span class="hljs-literal">()</span>;
            } catch (IOException e) {
                e.print<span class="hljs-constructor">StackTrace()</span>;
            }
        }
        Sheet sheet = wb.get<span class="hljs-constructor">SheetAt(0)</span>;
        <span class="hljs-keyword">for</span> (<span class="hljs-built_in">int</span> r = <span class="hljs-number">1</span>; r <= sheet.get<span class="hljs-constructor">LastRowNum()</span>; r++) {
            Row row = sheet.get<span class="hljs-constructor">Row(<span class="hljs-params">r</span>)</span>;
            <span class="hljs-keyword">if</span> (row<span class="hljs-operator"> == </span>null) {
                continue;
            }
            <span class="hljs-keyword">if</span> (row.get<span class="hljs-constructor">Cell(0)</span><span class="hljs-operator"> == </span>null) {
                row.create<span class="hljs-constructor">Cell(0)</span>;
            }
            <span class="hljs-keyword">if</span> (row.get<span class="hljs-constructor">Cell(2)</span> != null) {
                row.get<span class="hljs-constructor">Cell(2)</span>.set<span class="hljs-constructor">CellType(Cell.CELL_TYPE_STRING)</span>;
            }
            String t = row.get<span class="hljs-constructor">Cell(2)</span>.<span class="hljs-keyword">to</span><span class="hljs-constructor">String()</span>;
        }
    }

setCellType可以设置接收什么类型 建议都设置为string、然后在做转换比较好