Forum:

Upload Excel data into MySQL Server (Remotely access)

Greenhorn

Posts: 13

posted 1 year ago

Number of slices to send:

Optional 'thank-you' note:

Send

How to upload excel sheet into MySQL Server (remotely).

I have three column

*Client Name
*Date
*Message

and have 10 row approx.

how can I do that with python, VBA and JSP.

Tim Moores

Saloon Keeper

Posts: 6802

162

posted 1 year ago

Number of slices to send:

Optional 'thank-you' note:

Send

What part are you having problems with, specifically - uploading a file, extracting data from a spreadsheet, or saving to the DB? What do you have so far?

Since you mention JSP, I'm assuming this is a Java web app, where this kind of thing would be done in a servlet or similar. So what do VBA or Python have to do with it?

Aneeket Bhatnagar

Greenhorn

Posts: 13

posted 1 year ago

Number of slices to send:

Optional 'thank-you' note:

Send

I have a excel file where I have 20 row or 3+ column, I need this file upload into MySQL database.

I used java script for fetch data from excel in show into html now I tried to convert html table data upload into MySQL Database,

Aneeket Bhatnagar

Greenhorn

Posts: 13

posted 1 year ago

Number of slices to send:

Optional 'thank-you' note:

Send

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>

<%@ page import="java.sql.*" %>
	<%@ page import="javax.sql.*" %>
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 
<script src="jquery-2.1.4.js"></script>
<script lang="javascript" src="xlsx.full.min.js"></script>
<link rel="stylesheet" type="text/css" href="styles.css">

<title>Insert title here</title> 
</head> 
<body>

//Add the data rows from Excel file.
        for (var i = 0; i < excelRows.length; i++) {
            //Add the data row.
            var row = table.insertRow(-1);
 
            //Add the data cells.
            var cell = row.insertCell(-1);
            cell.innerHTML = excelRows[i].Client;
 
            cell = row.insertCell(-1);
            cell.innerHTML = excelRows[i].Sender;
 
            cell = row.insertCell(-1);
            cell.innerHTML = excelRows[i].ReceivedTime;

cell = row.insertCell(-1);
            cell.innerHTML = excelRows[i].Subject;
 
            cell = row.insertCell(-1);
            cell.innerHTML = excelRows[i].WorkType;

cell = row.insertCell(-1);
            cell.innerHTML = excelRows[i].Processor;
 
            cell = row.insertCell(-1);
            cell.innerHTML = excelRows[i].Auditor;

}
 
        var dvExcel = document.getElementById("dvExcel");
        dvExcel.innerHTML = "";
        dvExcel.appendChild(table);
    };
</script>

// GET THE CELLS COLLECTION OF THE CURRENT ROW.
            var objCells = myTab.rows.item(i).cells;

// LOOP THROUGH EACH CELL OF THE CURENT ROW TO READ CELL VALUES.
            for (var j = 0; j < objCells.length; j++) {
                info.innerHTML = info.innerHTML + ' ' + objCells.item(j).innerHTML;
            }
            info.innerHTML = info.innerHTML + '<br />';     // ADD A BREAK (TAG).
        }
    }

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////        
//var mysql = require('mysql');
//var con = mysql.createConnection({
//host: "localhost",
//user: "root",
//password: "Root@1",
//database: "clarivateapp"
//});
//con.connect(function(err) {
//if (err) throw err;
//console.log("Connected!");
//var sql = "INSERT INTO workflow (Client_Name, Sender_Name) VALUES ('Company Inc', 'Highway 37')";
//con.query(sql, function (err, result) {
//if (err) throw err;
//console.log("1 record inserted");
//});
//});
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////        
</script>

</body>
</html>

Tim Moores

Saloon Keeper

Posts: 6802

162

posted 1 year ago

Number of slices to send:

Optional 'thank-you' note:

Send

OK, so no VBA or Python are involved at all.

If this was my problem, I'd upload the file to the server, use Apache POI to extract the data, and then JDBC to store it in the DB. Javascript can't do that last part anyway, so you need server code in any case.

No matter. Try again. Fail again. Fail better. This time, do it with this tiny ad:

Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop

https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton