Hi. I'm a new user of telerik radlistview control and I'm having some problems importing tables from excel into listview.
I think I can use loops to do this however I want to use datasource to import once. The problem is that I am not sure what type of data for datasource. Is it the same with listfillrange property (lisbox.list = variant) for listbox in excel like vba?
Can this work or not:

        Dim import As XlsxFormatProvider = New XlsxFormatProvider
        Dim wb As Workbook = import.Import(File.ReadAllBytes(exportfile))
        Dim ws As Worksheet = wb.Sheets(0)
        Radlistview.DataSource = ws.UsedRange

Hi Dess. Interestingly, I was able to import excel range to radlistview right now, but another problem appears here, when using this command:
radlistview.DataSource = DtSet.Tables (0)
It seems that it follows the changing radlistview format, exactly these columns are divided into equal parts, just like paste together value + format
Can I just fill in data without affecting column formatting?

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Dear Dess, 

** my problem
From the windows form (width = 640, height = 500) I have added radlistview control
I have formatted it (w = 630, h = 300) with 4 columns and 10 rows (width of columns 30,200,200,200, horrizonscrollbar = alwayhide)
From the form load event I used oledbconnection to add excel range to listview and succeeded but after using this method the table format has changed specifically: the width of the columns is divided equally, the size change table makes scroll bar appear itself
** new problem
In addition, I found problems with theme events
I use BreezeTheme for radlistview, before using it I can edit radlistview normally, however after adding breezetheme: I can only keydown once, radlistview will automatically esc and that box will only contain one price single treatment
---------------------------------------
Currently I have solved problem 1 by reformatting the table after using datasource
Problems with the theme event breeze I haven't found a solution yet.

hi dess,
I have this gif, which you can easily imagine than the current problem I'm having

https://1.bp.blogspot.com/-eOQCmnoUTxo/XYC04iCY9NI/AAAAAAAAAao/4J6R0mC31_4xvZLAJH_XCM-erYBXQmQ0gCLcBGAsYHQ/s1600/ScreenGif.gif

To clarify the problem, I have created a simple file.
After running the project, on the excel ribbon bar there will be a new tab with 2 buttons.
Each button will call a form and 1 radlistview comes with the theme
Here both windows forms are identical. The only small change is the listview size
However one won't work. : ((
Looking forward to hearing from you.
Thanks you.

my File: Radlistview-with-theme

Gif: Radlistview-Gif

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Hi,you can Creat New project vsto for excel addin and you will see the problem I have stated

mygif: Radlistview-Gif1

I have also updated your Telerik points.

Currently, the possible solution that I can suggest is to increase the ItemSize: 

Me.RadListView1.ItemSize = New Size(200, 30)

I hope this information helps.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik