Merge two Arrays data into one C#

Question

Merge two Arrays data into one C#

ankit goel 766

I am working on a c# windows project where i have two Object Arrays. Array1 contains data from the excel below.

I have another array which contains data from the excel below

I want to merge the both the arrays and produce a final array from which i can generate an excel array which has the data in the following format.

Please suggest me a solution about how to merge the compare the data of two arrays and merge them to create a final single array. Thanks in advance .

Viorel 122.6K Reputation points

2022-12-03T13:35:57.4+00:00

Show some details about the variables that hold your data in C#.

ankit goel 766

    public partial class Form1 : Form  
{  
    string selectedFile;  
    int iRow, iCol = 1;  
    object[,] valueArray;  
    List<string> list = new List<string>();  


  public static Excel.Workbook Open(Excel.Application excelInstance, string fileName, bool readOnly = false, bool editable = true, bool updateLinks = true)  
    {  
        Excel.Workbook book = excelInstance.Workbooks.Open(  
            fileName, updateLinks, readOnly,  
            Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,  
            Type.Missing, editable, Type.Missing, Type.Missing, Type.Missing,  
            Type.Missing, Type.Missing);  
        return book;  
    }  
    void dowork()  
    {  
        Excel.Application excel = null;  
        excel = new Excel.Application();  
        excel.Visible = true;  
        Excel.Workbook wkb = null;  
        wkb = Open(excel, selectedFile);  
        Excel._Worksheet sheet = wkb.Sheets[1];  
        Excel.Range range1 = sheet.UsedRange;  
    // Read all data from data range in the worksheet  
       valueArray = (object[,])range1.get_Value(XlRangeValueDataType.xlRangeValueDefault);  


        wkb.Close(true);  
        excel.Quit();  

        // CLEAN UP.  
        System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);  
        System.Runtime.InteropServices.Marshal.ReleaseComObject(wkb);  
        System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);  
        System.Windows.Forms.Application.Exit();  
    }

ankit goel 766 Reputation points

2022-12-03T15:28:20.613+00:00

@Viorel , I have posted the code which i have tried
Jack J Jun 25,296 Reputation points

2022-12-05T07:52:26.573+00:00

@ankit goel , Welcome to Microsoft Q&A, based on your description, I want to confirm if this two excel arrays are in the same excel sheet. Do you want to show the final array in the original excel file or in the new excel file?
ankit goel 766 Reputation points

2022-12-05T08:18:13.107+00:00

@Jack J Jun
,The excel arrays are in two different sheets and I want to show the final array in the new excel file.
ankit goel 766 Reputation points

2022-12-05T13:45:01.307+00:00

Hi @Jack J Jun , is there any update regarding my problem sir.

Accepted answer

0 additional answers

Your answer

Viorel 122.6K Reputation points

2022-12-03T13:35:57.4+00:00

Show some details about the variables that hold your data in C#.
ankit goel 766 Reputation points

2022-12-03T13:51:22.173+00:00

public partial class Form1 : Form { string selectedFile; int iRow, iCol = 1; object[,] valueArray; List<string> list = new List<string>(); public static Excel.Workbook Open(Excel.Application excelInstance, string fileName, bool readOnly = false, bool editable = true, bool updateLinks = true) { Excel.Workbook book = excelInstance.Workbooks.Open( fileName, updateLinks, readOnly, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, editable, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); return book; } void dowork() { Excel.Application excel = null; excel = new Excel.Application(); excel.Visible = true; Excel.Workbook wkb = null; wkb = Open(excel, selectedFile); Excel._Worksheet sheet = wkb.Sheets[1]; Excel.Range range1 = sheet.UsedRange; // Read all data from data range in the worksheet valueArray = (object[,])range1.get_Value(XlRangeValueDataType.xlRangeValueDefault); wkb.Close(true); excel.Quit(); // CLEAN UP. System.Runtime.InteropServices.Marshal.ReleaseComObject(excel); System.Runtime.InteropServices.Marshal.ReleaseComObject(wkb); System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet); System.Windows.Forms.Application.Exit(); }
ankit goel 766 Reputation points

2022-12-03T15:28:20.613+00:00

@Viorel , I have posted the code which i have tried
Jack J Jun 25,296 Reputation points

2022-12-05T07:52:26.573+00:00

@ankit goel , Welcome to Microsoft Q&A, based on your description, I want to confirm if this two excel arrays are in the same excel sheet. Do you want to show the final array in the original excel file or in the new excel file?
ankit goel 766 Reputation points

2022-12-05T08:18:13.107+00:00

@Jack J Jun
,The excel arrays are in two different sheets and I want to show the final array in the new excel file.
ankit goel 766 Reputation points

2022-12-05T13:45:01.307+00:00

Hi @Jack J Jun , is there any update regarding my problem sir.

Answer 1

Jack J Jun 25,296

@ankit goel , you could try the following code to Merge two Arrays data into one Array.

code.txt

Note: I could not post the related code in the answer, so I used txt file to replace it.

Tested result:

Best Regards,
Jack

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

ankit goel 766 Reputation points

2022-12-06T03:38:50.15+00:00

@Jack J Jun , The code is working great. However there is one slight problem.

if (list[i].ToString().ToUpper().StartsWith("MR"))

Names in the second array from which the list has been made does not necessarily starts or contains the abbreviation "Mr. "

Jack J Jun 25,296

@ankit goel , thanks for the feedback, you could try to use the following code to replace the code I written before.

  for (int i = 0; i < list.Count; i++)  
        {  
            if (list[i].ToString().Trim()=="Textas"|| list[i].ToString().Trim()== "Florida")  
            {  
                //sheet.Cells[i + 1, 2].Value = dic1[list[i]];  
                sheet.Range[sheet.Cells[i + 1, 1], sheet.Cells[i + 1, 2]].Merge();  
            }  
            else  
            {  
                sheet.Cells[i + 1, 2].Value = dic1[list[i]];  
                
            }  
                 
            sheet.Cells[i+1, 1].Value = list[i];  
        }

Jack J Jun 25,296 Reputation points

2022-12-08T09:07:41.413+00:00

@ankit goel , is any update? Did you still have some questions about the problem?
ankit goel 766 Reputation points

2022-12-08T09:11:40.773+00:00

No sir @Jack J Jun . This particular problem has been solved. Thanks sir

Share via

Merge two Arrays data into one C#

0 additional answers

Your answer