ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Resize XML Table (https://www.excelbanter.com/excel-discussion-misc-queries/251282-resize-xml-table.html)

mcambrose

Resize XML Table
 
I imported an XML table into Excel. I need to expand the size of the table,
but the normal copy and insert copied cells is not available to use on an XML
table. The only way I found to do this is to open the xML task pane and
select a column heading in the XML map. The column of data is selected and a
black border surrounds the data included in the column. I can then drag the
corner of the border to resize. This causes an autofil of data in to the new
rows. NOt really a problem, but is there any other way to to this. It seems
that I can delete rows from XML table using the normal delete row method.
Thanks for any suggestions. If I am not clear, please ask and I will explain
further.


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com