如何在Excel中获取多列的宽度 [英] how to get widths of multiple column in excel

问题描述

单元格的数量为23，但我需要以像素为单位的宽度任何帮助，谢谢

The number of cell is 23 but i need the width in pixel any help thanks

For nI = 1 To 23
            'UPGRADE_WARNING: Couldn't resolve default property of object apExcel.ActiveCell. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"'
            Call SetBorder(apExcel.ActiveCell.Borders, Microsoft.Office.Interop.Excel.XlBordersIndex.xlEdgeTop, Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous, Microsoft.Office.Interop.Excel.XlBorderWeight.xlMedium)
            'UPGRADE_WARNING: Couldn't resolve default property of object apExcel.ActiveCell. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"'
            apExcel.ActiveCell.Offset(0, 1).Activate()
        Next

推荐答案

这可能有助于您确定有多少像素:
http://support.microsoft.com/kb/214123 [

This might help you to determine how many pixels you have:
http://support.microsoft.com/kb/214123[^]

这篇关于如何在Excel中获取多列的宽度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！