Đã hoàn thành

Import Excel to MSSQL via ASP.NET Core 2.0 or 2.2 Razor Page

I require a page to be created in ASP.NET Core 2.0 or 2.2 Razor page that when called will;

1. look for an .xlsx file in a given folder

2. Import the .xlsx file rows into an MSSQL table called tblImportDataTemp (skipping the header row)

- during the import we should see the progress via an AJAX animated progress bar;

[login to view URL]

3. If the importer completes without error;

- copy the data from tblImportDataTemp to tblImportData (first truncating tblImportData)

- move the imported .xlsx file to another specified folder - prefixing the file with the timestamp of the move event.

4. If the importer encounters an error, send an email to advise the import failed using Mailkit

We will supply you with;

- sample .xlsx file

- sample database schema

- Bootstrap template

Requirements;

- Importer should use the NPOI package

- Mailer to use MailKit

- Code neatly formatted and not obfuscated

- Deploy and test code on our development server, and provide us instructions to deploy on production.

Useful Links:

[login to view URL]

MailKit

[login to view URL]

Kĩ năng: ASP, ASP.NET, Javascript, jQuery / Prototype, Microsoft SQL Server

Xem nhiều hơn: .net core 2.0 read excel file, import data from excel file to database table in asp.net mvc 5, asp.net core export to excel, import data from excel using epplus, .net core 2.0 excel export, epplus import excel to sql server, asp.net core export csv, export datatable to excel in asp net core, import excel mssql, import orkut friends asp net, import excel classic asp, write mongolian language excel files asp net app, code compare excel files asp net, connect excel project asp net, convert excel spreadsheet asp net web app, import excel dll asp net, upload bulk data excel mssql asp net, upload data excel mssql asp net, asp.net core 2.0 spa, asp.net core 2.0 react tutorial

Về Bên Thuê:
( 20 nhận xét ) Lismore, Australia

ID dự án: #18699672

Được trao cho:

saad2038

Hi, I can help you to create a page in ASP.NET Core 2.0 or 2.2 Razor page that import the excel file data into temp table of database and after successfully import move that data to temp table to another table into dat Thêm

$235 AUD trong 3 ngày
(25 Đánh Giá)
5.5

3 freelancer đang chào giá trung bình $212 cho công việc này

WebInfoSolutions

Hello Sir, can i check the sample excel? also wanted to know the total lines it will have in real time. I have so far worked on below website. [login to view URL] [login to view URL] Kind Re Thêm

$150 AUD trong 7 ngày
(122 Nhận xét)
7.2
qprotex

Hello, My name is Miguel Febres and you can locate my resume and certifications in the following links: [login to view URL] [login to view URL] In my 10+ years of e Thêm

$250 AUD trong 3 ngày
(16 Nhận xét)
5.5