I am getting data from data table

how to create this type of table in uipath the i am getting the data from database

You seem to have two tables really rather than one. One is your core data, that above the Events Planned line.

And a second table below the Events Planned line.

Assign the relevant variables to each table and then you can append range into excel.

is it possible to get a sample showing fetching of data from database then passing the values from database to excel and then using to create that table please

I have no access to your database to design a workflow.

There are a number of databases packages which will help you pass data from the database to an object in UiPath, depending on the type of database you have

From these you will get an output. Please provide an example csv of the output provided by these UiPath activities.

i am using sql workbench which one should i use

Try UiPath database activities