如何根据映射的工作表更改列名称 [英] How Do I Change Column Name As Per The Mapped Sheet

问题描述

我有3张名为'sheet1'，'sheet2'和'mapping'表。



'Sheet1'包含实际数据（可以说原始数据和列号/标题名称可以不同）



'Sheet2'包含主表格列（Sheet1数据标题应按照表格2）



'映射'包括sheet1和sheet2之间的映射

I have 3 sheets named 'sheet1', 'sheet2' and 'mapping' sheet.

'Sheet1' consist the actual data (Can say raw data and column numbers/header name can be different)

'Sheet2' Consist the master sheet columns (Sheet1 data header should be as per the sheet2)

'mapping' consist the mapping between sheet1 and sheet2

| AB| AF| AL|   | C1| C2| C3|   |sheet1 column_name |  Sheet2 column_name|
|-----------|   |-----------|   |     AB            |    C1              |
| 1 | f | y |   |   |   |   |   |     AL            |    C2              | 
|---------- |   |---------- |   |     AF            |    C3              | 
| 2 | g | Q |   |   |   |   |   -----------------------------------------
|---------- |   |---------- |   
| 6 | i | e |   |   |   |   |   
-------------   -------------   
       "Sheet 1"     "Sheet 2"                  "Mapping"

我正在寻找可以根据映射表更新sheet1列的代码。就像映射表说AB=C1那样，sheet1列应该更新为C1



我用匹配函数尝试了但是没有成功任何其他的想法？



提前谢谢。

I am looking for code which can update sheet1 columns as per the mapping sheet. Like if mapping sheet says "AB" = "C1" then sheet1 column should be updated as "C1"

I have tried it using matchfunction but didn't get success.any other idea?

Thanks in advance.

推荐答案

如果你在谈论XML映射，请看这里：在Excel 2010中创建XML映射架构 [ ^ ]，将XML数据导入Excel 2010中的映射列表 [ ^ ]。

如果没有，请告诉我，我会尽力改善答案。

If you're talking about XML mapping, have a look here: Creating an XML Mapping Schema in Excel 2010[^], Importing XML Data into a Mapped List in Excel 2010[^].
If not, let me know and i'll try to improve my answer.

这篇关于如何根据映射的工作表更改列名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！