SeriesCollection和FullSeriesCollection之间的区别 [英] Differences between SeriesCollection and FullSeriesCollection

问题描述

我正在尝试清除一些自动生成的代码，而我对excel中的系列功能还是比较陌生.因此，在许多网站/论坛中，我发现人们使用了更多的 SeriesCollection 而不是我使用 FullSeriesCollection 生成的代码.

I am trying to clean some auto generated code and I am rather new with the series functionality in excel. So in many websites/forums I found people using a lot more SeriesCollection instead of my generated code using FullSeriesCollection.

我的代码正在过滤某些内容，然后设置图表的x轴值，因此可以做到这一点:

My code is filtering some stuff and then it is setting the x axis values of a chart so it is doing that:

.ChartObjects("Voltage").Chart.FullSeriesCollection(1).XValues ="= Parametric_Sheet！D:D"

我试图知道此代码是否正确，或者我是否可以清除它.

I'm trying to know if this code is ok or not or if I can clean it.

推荐答案

确保其他人会提供更多信息.

Sure someone else will give more info.

至少一个区别是seriesCollection在整个Excel版本中都向后兼容.

At least one difference is seriesCollection is backwards compatible across Excel version.

您的代码适用于较新的Excel版本，但如果要确保跨版本的兼容性，请改用seriesCollection.

Your code is fine for newer Excel versions but if you want to ensure compatibility across then use seriesCollection instead.

这篇关于SeriesCollection和FullSeriesCollection之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！