How to get text from shape?

[Sa_Ge]

Hello O Great Helpers,
How can i extract text from specific shape?
Exp.xlsx (9.0 KB)
Thanks alot

[whitestar (Phyo)]

Try this vb code ?

How to read script from Textbox inside excel sheet and paste into portal

The above solution will work but it has to open the workbook. If you are not willing to do that, VB code will be an another option. Try this code and let me know if this helps @prashantP Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As Microsoft.Office.Interop.Excel.Worksheet excel = New Microsoft.Office.Interop.Excel.Application wb = excel.Workbooks.Open("D:\UiPath\CopyAndPasteInExcel\samplefile.xlsx", [ReadOnly]:…

[ptrobot]

The code @whitestar refer to should work fine if you use it inside an Invoke Code activity and change “AlternativeText” to “TextFrame.Characters().Text”.

If you prefer C# instead of VB.NET:

string excelFile = Path.Combine(Directory.GetCurrentDirectory(), @"Data\Exp.xlsx");

Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();

Microsoft.Office.Interop.Excel.Workbook wb = excel.Workbooks.Open(Filename: excelFile, ReadOnly: true);
Microsoft.Office.Interop.Excel.Worksheet sheet = wb.Sheets["Sheet1"] as Microsoft.Office.Interop.Excel.Worksheet; 

// To read a specific shape
Microsoft.Office.Interop.Excel.Shape foundShape = sheet.Shapes.Item("Rectangle 36");
System.Windows.MessageBox.Show(foundShape.Name + ": " + foundShape.TextFrame.Characters().Text);

wb.Close(SaveChanges: false);
excel.Quit();

It might be tricky to get Invoke Code to work with Interop.Excel. See this post on how to get it to work: HOWTO: Use MS Office COM interop with UiPath

[Sa_Ge]

Thanks for the reply but do i need to configure trust center in excel to be able to invoke code? truly sorry for my naivety and late reply.

[Sa_Ge]

Thanks alot for helping sir

[ptrobot]

You are welcome!

No, you don’t need to configure Trust Center to get Invoke Code to work. Invoke Code executes real code (i.e. not a macro/VBA).

[Sa_Ge]

Thanks