LoginSignup
0
0
@Miki_Yokohata(横畑 実樹)inSharperlight Users

【Excel Addin】Displaying writeback logs in a textbox

Posted at

Introduction

This time I will explain how we can display the writeback process logs in a textbox rather than the default popup dialog or cells on the sheet.

Configureing writeback logging option

I prepared an Excel workbook with a Sharperlight writeback definition.
image.png

The writeback does insert/update to the Ledger table in this database.
image.png

Insert a textbox and rename the name of the textbox.
image.png
You can also use the default name.
image.png

Open the writeback definition by clicking the gear icon.
image.png
Display the definition by clicking the lookup button for Writeback Name field.
Choose Ledger.
image.png

Once the definition is loaded, you can go for Processing Options tab.
image.png

Specify the name of the textbox, i.e. =TextBox 1 into Logging Cell option.
image.png

Save the changes and close the writeback definition.

Click the Execute Writeback button.
image.png

The process log would be displayed like this.
image.png

Conclusion

This will allow for greater extensibility in report design.

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
0