如何读取Excel工作表数据并在完成排序后将其写入另一个Excel工作表 [英] How to Read an Excel sheet data and write it to another Excel Sheet After Sorting Done
问题描述
嗨朋友们,
我想从Excel Sheel读取某些数据并将其写入另一张Excel表格中,如下所示。
A1.Xlsx
栏目名称:
www.Google.co.in
asdfsfsdfsddsdds / Dumb letters
www.Google.Co.hk
Www.yahooo.com
www.codeproject.com
我需要创建另一个名为B1的Excel,因为我需要将这些数据复制到另一个Excel工作表并保存的有效地址是什么。除非愚蠢的字母我应该省略那些东西。这可能与VB脚本或java脚本或powershell有关。
如果它有任何其他简单的方法也让我知道。
Hi Friends,
I wants to Read a Certain data from Excel sheel and Write it into another Excel Sheet like below.
A1.Xlsx
Column Names:
www.Google.co.in
asdfsfsdfsddsdds/Dumb letters
www.Google.Co.hk
Www.yahooo.com
www.codeproject.com
Where I needs to create an another Excel called B1 in that what are the Valid addresses that i needs to copy those data only to another Excel sheet and save. Unless the Dumb letters i should omit those things. so is that possible to do with VB script or java script or powershell.
Please if its there any other easy method also let me know that.
推荐答案
假设您的PC上有Excel,我会使用VBA并创建一个宏。
作为帮助,你您可以在录制宏时手动执行所需操作。
宏将显示要遵循的步骤。录制的宏需要进行一些调整。
Assuming you have Excel on your PC, I would use VBA and create a macro.
As an help, you can manually do what you need while you record a macro.
The macro will kindly show the steps to follow. The recorded macro will need some tweaking.
这篇关于如何读取Excel工作表数据并在完成排序后将其写入另一个Excel工作表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!