Click here to Skip to main content
13,625,600 members
Rate this:
 
Please Sign up or sign in to vote.
See more:
Hello Everyone,

I'm not sure how to upload a sample file for a question. So pasting the content directly here.

i have the following .xlsx file.

Application Field Detail: Control Procedures					
System Name: DPE Archer GRC  Version: 6.1.00201.1002					
Tuesday, October 10, 2017					
Application Name:	Control Procedures				
Description:	sss				
Status:	Production				
Application Owner(s):	"CM: Admin
PM: Admin"				
Field Calculation Order:	ssss				
Recalculation Schedule:	0 Days  				
Application Fields					
General:	Field Name:	Procedure ID			
	Alias:	Procedure_ID			
	Field ID:	{426748AB-F600-4930-9CBE-AC176F9924FD}			
	Field Type:	Tracking ID			
	Status:	Active			
	Description:	"This field is automatically populated with a value that 
uniquely identifies the record across all applications within 
the system."			
	Display Control:	Read Only			
	Field Permissions:	Public			
Options:	Search Results:	Yes		Search Default:	Yes
	Key:	No			
Configuration Attributes:	ID Type:	System ID			
	Prefix:				
	Suffix:				
Help Text:	Text:	"This field displays a value that uniquely identifies the record 
across all applications within the system."			
	View Display:	Tooltip			
	Edit Display:	Tooltip			
General:	Field Name:	Last Updated			
	Alias:	Last_Updated			
	Field ID:	{FD766D6A-7EB3-462B-B32B-F81612504336}			
	Field Type:	Last Updated Date			
	Status:	Active			
	Description:	"This field is automatically populated with the date the record 
was last updated."			
	Display Control:	Read Only			
	Field Permissions:	Public			
Options:	Search Results:	Yes		Search Default:	No
	Include Time:	Yes		Include User:	Yes
	Header Display:	Yes			
Help Text:	Text:	This field displays the date the record was last updated.			
	View Display:	Tooltip			
	Edit Display:	Tooltip


I would like to convert that into the following format
Application/Questionnaire	Field Name	Field Alias	Field ID	Status	Level	Field Type	Description	Help Text	Required?	Calculated Field?
Control Procedures	Procedure ID	Procedure_ID	{426748AB-F600-4930-9CBE-AC176F9924FD}			Tracking ID	"This field is automatically populated with a value that 
uniquely identifies the record across all applications within 
the system."	"This field displays a value that uniquely identifies the record 
across all applications within the system."		
Control Procedures	Last Updated	Last_Updated	{FD766D6A-7EB3-462B-B32B-F81612504336}			Last Updated Date	"This field is automatically populated with the date the record 
was last updated."	This field displays the date the record was last updated.		
Control Procedures	Description	Description	{8AAB3C20-FE24-40BE-B5D6-90F32C2B8767}			Text	This field is used to describe the control activity.	Enter a detailed description of the control activity.		No
Control Procedures	Control Placement	Control_Placement	{0BC9C8A6-D992-4A3A-801D-2D10E081C13E}			Values List	"This field indicates whether the control is preventive or 
detective. For definitions, see the field-level help text."	"Select whether the control is preventive or detective 
according to the following definitions:"



I am struggling to device some sort of logic. Could i get some help?

Regards,
Swayam

What I have tried:

I pretty much struggled with the logic. So could not start at all.
I would be great if i could get some guidance.
Posted 3-Jan-18 8:40am
Updated 3-Jan-18 22:50pm
v2
Comments
Maciej Los 3-Jan-18 15:18pm
   
Are you sure it is xlsx file? It might be csv file.
swayamrath 3-Jan-18 16:38pm
   
It's xlsx. :)

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

I am not sure what that is you have posted, but it does not look anything like the contents of an Excel file. However, see Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] for a simple way to extract all the content of a workbook.
  Permalink  

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web04 | 2.8.180712.1 | Last Updated 4 Jan 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100