Compare RTF file with Excel file and generate separate RTF file based on group assigned in excel using C# and VB.Net in ASP.Net

mod7609

SOLVED
User: mod7609
Posted: on Jul 03, 2017 03:49 AM
Forum: Excel
Answer: 1
Views: 6860
Sample Code: Download

Dears,

I have a RTF file including several different references and three groups, and also I have an excel database including some references in three groups too.

I would like to compare the references which are in RFT file with the all the references in excel file and separate references based on their group and export three separated RFT file.

I attached these two file in following link:

https://www.file-upload.com/ydxpfmbi9eym

https://www.file-upload.com/dwcxnxlihr8f

Can somebody help me in this regards ? how I can handle it ?

Download FREE API for Word, Excel and PDF in ASP.Net

dharmendr

0 1

ANSWER
User: dharmendr
Replied: on Jul 03, 2017 06:26 AM
Report

Hi mod7609,

Please paste the RTF and Excel file data here.

mod7609

0 2

ANSWER
User: mod7609
Replied: on Jul 03, 2017 06:51 AM
Report

dharmendr says:
Hi mod7609,

Please paste the RTF and Excel file data here.

it was not possible to paste file here but you can find some thing of the data as follow :

RTF File :

Nr	Case Nr	References	Goods designation	Quantity	Total net weight, kg	Total gross weight, kg	Country of origin

1	126178212			64	426,880	451,380
		8200537190	COMPR	64	426,880	451,380	TH
2	126179212			64	426,880	451,380
		8200537190	COMPR	64	426,880	451,380	TH
3	130701211			480	547,200	571,700
		765872424R	REINF- SIDE IMPACT RE	480	547,200	571,700	EU
4	130718211			480	547,200	571,700
		8200536832	REINF- SIDE IMPACT RE	480	547,200	571,700	EU
5	155932212			336	493,920	518,420
		476604621R	UNIT-ABS HYD	336	493,920	518,420	EU

Excel file :

Refrences	Name of Group
8200537190	Group 1
8200537190	Group 1
765872424R	Group 2
8200536832	Group 1
476604621R	Group 3

thanks for your help

dharmendr

0 3

ANSWER
User: dharmendr
Replied: on Jul 03, 2017 07:22 AM
Report

Will you please provide the required output?

mod7609

0 4

ANSWER
User: mod7609
Replied: on Jul 03, 2017 07:56 AM
Report

dharmendr says:
Will you please provide the required output?

As you see , all Refrencess are in just one RTF file (5Ref), I want to seperate this refrences with their data based on database and group name, and issue 3 new RTF file
for excample one file for Group 1

another for Group2

and another one for Group 3

Thanks

dharmendr

0 7

ANSWER
User: dharmendr
Replied: on Jul 06, 2017 03:37 AM
Modified: on Jul 06, 2017 03:38 AM
Report

Hi mod7609,

Your word document contains the record in table format like below or in any other format or in sinple text without table format?

Nr	Case Nr	References	Goods designation	Quantity	Total net weight, kg	Total gross weight, kg	Country of origin
1	126178212			64	426,880	451,380
		8200537190	COMPR	64	426,880	451,380	TH
2	126179212			64	426,880	451,380
		8200537190	COMPR	64	426,880	451,380	TH
3	130701211			480	547,200	571,700
		765872424R	REINF- SIDE IMPACT RE	480	547,200	571,700	EU
4	130718211			480	547,200	571,700
		8200536832	REINF- SIDE IMPACT RE	480	547,200	571,700	EU
5	155932212			336	493,920	518,420
		476604621R	UNIT-ABS HYD	336	493,920	518,420	EU

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Compare RTF file with Excel file and generate separate RTF file based on group assigned in excel using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us