Một tháng trước em có viết đoạn code này để ẩn sheet 1 trong biến workbook là wbMikomi
wbMikomi.SetSheet(“Sheet1”, false)
wbMikomi.CurrentWorksheet.Visible = Microsoft.Office.Interop.Excel.XlSheetVisibility.xlSheetHidden
Giờ chạy lại lỗi như bên dưới:
Message: Error compiling code\n
error BC31000: The embedded interop type ‘Visible’ does not contain a definition for ‘Microsoft.Office.Interop.Excel.Worksheet’ since it was not used in the compiled assembly. Consider casting to object or changing the ‘Embed Interop Types’ property to true. At line 2
error BC30456: ‘XlSheetVisibility’ is not a member of ‘Excel’. At line 2
Stack trace:
at RCA.Activities.Core.CompilerRunner.Compile(String code, Int32 errLineOffset, Boolean generateInMemory)
at RCA.Activities.Core.InvokeCode.GetCompilerRunner(String userCode, List`1 args, String imps)
at RCA.Activities.Core.InvokeCode.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
2020/10/29 2:10:43 Information No0RoboTemplate execution ended
Không biết là giờ muốn ẩn sheet của 1 file excel thì phải làm thế nào trên akabot?