How to reading excel cell and cell value changing saving database in C#?

Question

0.00/5 (No votes)

See more:

I want to read the excel cell and change it to bank if it is official banker.
So before that line, how can I read the cell with the control and change it to the word bank.

Bank Official change Bank.And Copy to database table Bank word.

How to read cell value and change?
Excel File

ID DEPARTMENT DEPARTMENTSHORTNAME

1 BANKER BANK

2 DOCTOR DOC

3 BANKER OFFICIAL BANKER OFFICIAL

4 BANKER OFFICIAL BANKER OFFICIAL

I want to database table is:

ID DEPARTMENT DEPARTMENTSHORTNAME

1 BANKER BANK

2 DOCTOR DOC

3 BANKER OFFICIAL BANK

4 BANKER OFFICIAL BANK

What I have tried:

Read Data from the Sheet.Use Open sql command and read excel file code.

Posted 22-Jun-19 12:11pm

StudentSC

Updated 3-Jul-19 9:32am

v3

Add a Solution

Comments

ZurdoDev 1-Jul-19 14:01pm

Where are you stuck?

Sinisa Hajnal 3-Jul-19 2:08am

What is the problem with the code? Reading values from excel is well documented and replacements can be done through dictionary, either in code or in the database table. You can do replacements in the code or within stored procedure which inserts new data (just consult your short names table).

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2019-07-03T09:32:00

Seems, you want to replace BANKER OFFICIAL with BANK.

I've already showed you up how to achieve that here: How do I read excel in C#?[^]

If you would like to get more information about how to read Excel files, please read the documentation! Start here: How to automate Microsoft Excel from Microsoft Visual C#.NET - Office | Microsoft Docs[^]
Automate Excel by using Visual C# to fill or to obtain data by using arrays - Office | Microsoft Docs[^]
Transfer data to an Excel workbook by using Visual C# 2005 or Visual C# .NET - Office | Microsoft Docs[^]